Hi All,

I believe I have tried every way presented and I could not make any work.

I went back and made a value list for the carid using the SQl DB

        SELECT  carid
        FROM    cars
       WHERE dateCreated > '2006-01-01'
           AND dateCreated < '2006-01-11'

I then went and applied the vailue list to the access queries and I have my data now.

I hope that soon we will be off of this access Db.

Thanks to everyone for your suggestions and thoughts.

Regards

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


_______________________________________________
Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/

Reply via email to