I'm using a form to run a query. I have a start date and an end date on the form and I want to only return records in the query that fall between those dates. If the dates are left blank, I want the query to return every record. The fields use the Short Date format. I would prefer to do this as...
I have created a query to show on which week numbers of the year, customers have bought products. I now want to show the week numbers in which each customer has not bought anything.
Can anyone explain how to do this?