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/