[AccessD] Date Issue

I think that if you do it as a parameter, you do not need the #s around the
date.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Terri Jarus
Sent: Wednesday, January 05, 2005 10:07 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Date Issue


So much for easy - in my Query Grid for Start Date, I place the
criteria:  >#12/1/04#  and I get what I need.  However, if I want the user
to put in the date, such as [Enter Date], I get all the data again.  I try
entering the date at the prompt as #12/1/2004# and it still doesn't work.
 
Any ideas - why is this just not recognizing that the data is a date???
 
Thanks.
 
Terri Jarus
Vice President, Contract Services
jarus at amerinet-gpo.com
314-542-1902