Filter Records

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

With the help of this group I have been learning that you can do many things
with reports using expressions. Before this, I would make my query and pull
information from there. I was wondering if I Could filter out records in a
report? I have a query that is based on another query which my report is
pulling it's information from. The query gives me the names and total
number of hours employees have taken time off for the last 3 years so my
reports keeps adding up the total hours for 3 years. I only want to show
the records from the current quarter in my report. A quarter for us is
Jan-Mar, April-June, July-Sept, Oct-Dec. I am using Access 2000. Is there
any way I can do this without knowing a bunch of programming?

Thanks,
Linda
 
Create a form "frmDates" with a couple text boxes "txtStartDate" and
"txtEndDate". Open the form and enter your dates. Then open the report in
design view and set the criteria on the date field in the record source to:
Between Forms!frmDates!txtStartDate and Forms!frmDates!txtEndDate
 
Hi Duane,

I already have a form that we enter the date of time off and the number of
hours taken off called frmVTO, this data is stored in a table tblVTO. I
have a query that gives a total sum of the hours taken so far qryVTOTotal.
The dates the employee took off is not important for this report only the
number of hours total taken in the current quarter.

I already have a report that gives me the employee name and the sum of hours
they have taken off. These hours are sorted in descending order in the
query but it shows records for the entire 2 years, I just want the sum of
hours for each quarter during that quarter and for the first day of the new
quarter everyone should be back to zero hours. I do need to keep the total
hours for another report but for this report I need it by current quarter.

Thanks,
Linda
 
Back
Top