I need to create one query to run every day , using Microsoft Access that finds records from the previous work day. Tues to Friday, the previous work day is date()- 1. Simple enough. But on Monday, if I use date()-1, it will miss records from that previous Friday or Saturday. its an iif statement but I need help with the rest please.