Printing Report between two dates (1 Viewer)

[mykil]

Hello everyone!!!

Do you have any code for viewing Report between two dates. So when you open the report it will ask for the starting date and ending date. Any help will be much appreciated!!! Thank you in advance!!!

 

[JHB]

Base your report on a parameter query.
The link below show you how to do that.
http://office.microsoft.com/en-us/a...ers-with-queries-and-reports-HA001117077.aspx

 

[mykil]

Thanks a lot!!! You're link really helps!!!

 

[JHB]

You're welcome.

 

[sumox]

ya create a query
then feed in date field :
between Forms!SearchFrm!fromdate and Forms!SearchFrm!todate
then
Create a Form
Insert two textboxes one by one
Right-click those and goto Properties---> Other tab :
change name to "fromdate" (without quotes)
now do this for next textbox
rename it as "todate" (without quotes)

and then insert a command button specify--> Preview report--->Select your report
and then. Click finish

Now Save this form as "SearchFrm" or if previously named then Rename
it just like in windows we rename files.

now whenever you open form
fill fromdate and todate fields with range of dates
and then click Commandbutton. then a Report will Occure inPreview Mode
filtered by Query made by you.
(NotE:- your report shud be created by wizard, if you're novice/newly unknown to Access !)

thanks for reading