[AccessD] Date Issue

I thought of that too and tried that - if I put in a parameter of
#12/1/04#, it works.  However, if I want to prompt for the date such as
[Enter Date], and I actually type in #12/1/04# with the #'s, it still
doesn't work.  I can't figure it out?
 
Terri Jarus
Vice President, Contract Services
jarus at amerinet-gpo.com
314-542-1902

>>> bheid at appdevgrp.com 1/5/2005 9:26:37 AM >>>

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


---------------------------------------------------------------------------
This email and any files transmitted with it are confidential and
intended solely for the use of the individuals or entities to whom they
are addressed. If you have received this email in error please return 
it to the sender, and erase any copies thereof.
Copyright 2004 Amerinet 1nc.