I'm probably going about this the wrong way, but I'm trying to filter a report to show only hourly employees in a date range. The date range works fine, [Date]>=[Beg] And [Date]<=[End]
But when I add [Date]>=[Beg] And [Date]<=[End] And [Budget]![ID]="djm" Or "gna" Or "jtv" Or "mdw" Or "mtc" nothing works, not eve the date filter. "Budget" is my query and "ID" is the employee ID in the Budget Query.