I have a query and i want the report to print out details of employee cash required that week.
These have been input in tblHours.
However i have set the query up with 'True' in the criteria for each of the Cash fields. so as not to print off all employees including those without cash.
these are my fields:
EmpId
Week No
Cash
Petrol Receipts
Other Receipts
Miscellaneous
i understand that i cannot put true as the criteria for all four fields as the query will only look for those people with all four fields filled in however i would like the report to print everyone with a total other than £0.00 in any of those four fields.
any help is much appreciated.
thanks
These have been input in tblHours.
However i have set the query up with 'True' in the criteria for each of the Cash fields. so as not to print off all employees including those without cash.
these are my fields:
EmpId
Week No
Cash
Petrol Receipts
Other Receipts
Miscellaneous
i understand that i cannot put true as the criteria for all four fields as the query will only look for those people with all four fields filled in however i would like the report to print everyone with a total other than £0.00 in any of those four fields.
any help is much appreciated.
thanks