MS Query 2000 on dates with parameters
Figured out the problem. Extra date field was causing the problem when using
a Sum formula. Then the date format in MySQL had to be yyyy/MM/dd. Then it
worked.
Thanks
"Shane Devenshire" wrote:
Hi,
This works for me on the Criteria row in MS Query:
=[Start Date] And <=[End Date]
as does this
Between [Start Date] And [End Date]
Try looking at the SQL statement in MS Query - in my case it is
WHERE (Employees.HireDate Between ? And ?)
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"rasinc" wrote:
I am trying to get a query with parameters on a date field to show up properly.
#3/01/2009# And <#3/31/2009#
This above statement works in the date field criteria.
#3/01/2009# And <[Please enter an ending date]
This above statement does not.
Ultimately I want to set it up to do this
=[Please enter a start date] And <=[Please enter an ending date]
Is there any better way to do this or to make the above work properly?
Database is MySQL if it matters.
Any help is appreciated. rasinc
|