So everything that you type in as criteria returns errors? Is the Date field in your table formatted to be a date? Is it just the date field or all of the fields?
So everything that you type in as criteria returns errors? Is the Date field in your table formatted to be a date? Is it just the date field or all of the fields?
So apparently my last post didn't post.
So you can't enter any critereia without gettig an error?
Or just not in the Date field?
In the table, is the field formatted as a date?
Try starting over in a new query to see if it changes anything
Edit: Oops, double posted.