Date Parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

One more question. I have report that displays information grouped by year. I
would like to add a parameter to the query that asks [Enter Year:] they would
enter the year 2005 and it would only display 2005 data. I currently get an
error when I tried the above as it stands now I have between[Beginning Date:]
and [Ending Date:] which works but I would like to simplify for the user.
 
Change your criteria to:

BETWEEN DateSerial([Enter Year:], 1, 1)
AND DateSerial([Enter Year:] + 1, 1, 0)

(assuming that you hane zero time component in your date Field used with the
abovecriteria)
 
Thanks that did it!!

Van T. Dinh said:
Change your criteria to:

BETWEEN DateSerial([Enter Year:], 1, 1)
AND DateSerial([Enter Year:] + 1, 1, 0)

(assuming that you hane zero time component in your date Field used with the
abovecriteria)

--
HTH
Van T. Dinh
MVP (Access)


Branden said:
One more question. I have report that displays information grouped by year. I
would like to add a parameter to the query that asks [Enter Year:] they would
enter the year 2005 and it would only display 2005 data. I currently get an
error when I tried the above as it stands now I have between[Beginning Date:]
and [Ending Date:] which works but I would like to simplify for the user.
Click to expand...
Click to expand...
 
Back
Top