Query for report

  • Thread starter Thread starter Intruder via AccessMonster.com
  • Start date Start date
I

Intruder via AccessMonster.com

I have a totals query that pulls out TotDaysVac and SumOfVac. I would only
like to list the days on my report where TotDaysVac-SumOfVac =0 how do I do
this??
 
I have a totals query that pulls out TotDaysVac and SumOfVac. I would only
like to list the days on my report where TotDaysVac-SumOfVac =0 how do I do
this??
Click to expand...

Add a new column to your query.
DaysLeft:[TotDaysVac]-[SumOfVac]

as criteria on this column, write:
=0
 
Back
Top