Conditional Criteria for a Date Field in a Query

[Brianwarnock]

For any non American who has followed this thread let me add that the dates on the forms will be in your local format ie in my case dd/mm/yyyy,
you only need American format when hard coding dates in SQL and VBA.


Brian