BadBoy House
Registered User.
- Local time
- Today, 09:01
- Joined
- Oct 8, 2009
- Messages
- 54
Hi all,
We have a report in our job database which lists all of the jobs currently booked in; it sorts each record based on the date it was booked in.
I would now like to create some additional reports, for example all jobs booked in over 60 days ago.
Is it possible to add selection criteria to Access reports? So could I take a copy of the all jobs currently booked in report and add a date criteria so that it only selects records >60 days since they were booked in?
Would it be best to set up a new query that selects only the required information for the report, or can this type of criteria be specified within the report designer?
Many thanks
We have a report in our job database which lists all of the jobs currently booked in; it sorts each record based on the date it was booked in.
I would now like to create some additional reports, for example all jobs booked in over 60 days ago.
Is it possible to add selection criteria to Access reports? So could I take a copy of the all jobs currently booked in report and add a date criteria so that it only selects records >60 days since they were booked in?
Would it be best to set up a new query that selects only the required information for the report, or can this type of criteria be specified within the report designer?
Many thanks