Ray,
Did you try the pound sign solution?  What was the result?

Ryan


On 7/10/06, Ray Hughes <[EMAIL PROTECTED] > wrote:
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/



--
Ryan Everhart
[EMAIL PROTECTED]
_______________________________________________
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