Selective Reporting

[Ringers]

I have a service record database, which i enter calls that i recevice. Now what i want to is print reports for only today, so that i can show my super what calls i have taken and what actions. Their is a service_date field link to the actions memo field.

When i setup a report it shows all records how do you filter it, i am a newbie to this so help would be great.

Thanks

 

[KenReay]

Hi

At its most basic

base your report on a query rather than a table, in the query put [Enter Date] as the criteria of the service date,

or

a slight variation, if you ALWAYS want todays calls only, set the criteria as =Date()

As I said this is teh most basic way to do it, for a more user friendly way to do it you would set up a form which would have a taxt box to prompt for the date, and maybe a pop up calendar, and a command button to run the report, the criteria would then by Forms![MyForm]![MyDate] (using your own form and control names of course)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK