Reports in Access? Time/Date

[Guy Hocking]

Hi There,

I am relatively new to Access (2002) so forgive me.
I wish to make a form , with a button, that when pressed prompts for a start
date, then an end date, then a start time then a end time......

So a report then displays the data from the specified time/date period. How
would i go about making the report/form/query to do this?
Once i get this around my head i can successfully to the other reports (i
think?!)

Thanks


--
GH

www.bradflack.com

Please remove ANTI and SPAM from my
email address before sending me an email.

 

[Guest]

A good way to do this is to set parameter values in a
queries SQL design view that reference a form used to
input the ranges. Then set up the reports On_Open event
to pull up the form. There is a lot to it, but you can
find a great example of this in the Northwind Sample
database that comes with Access. Check out the
report "Sales by Year" and its underlying query as well as
the form "Sales by Year Dialog"