Query for report

[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??

 

[fredg]

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??

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

as criteria on this column, write:
=0