Date Parameter Queries

[dfuas]

Hi everybody,

I have a report that is based on an underlying query.At the query level,I
want to define parameters of date data type so that records to be displayed
should fall between DateA and DateB. ie Between[Enter Date A:] And [Enter Date B:].
I want the DAteA and DateB to be only days and Months of a year.

Say my DateA = 01 Jan 06 and my DateB = 31 Dec. 06

But I want only the Parameter to be Between[Enter day and Month A:] And [Enter day and Month B:].


How can I write a query with the two parameter values?

Thank you

dfuas

 

[gromit]

Hi -

The approach that comes to my mind is to enter both parameters as dates, and then ignore the year value. One way to do this is to use functions to check the serial # of the day.

E.g.
DATEPART ("y", DateVariable)

See this thread for just a little more discussion.
(http://www.access-programmers.co.uk/forums/showthread.php?t=98369

Hope that helps.

- g