Multiple dates in Criteria section

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Learning to create a query. Required to input multiple dates in the criteria
section and not sure how to do that or if it's even possible! Keep getting
the message "Data Mismatch". Other criteria required is name, #of guests and
notes. I can't figure this one out, and Unit Workbook is no help at all!!!
Heeelllppp!!!!
 
The error message "Data mismatch" implies that what you are entering as
criteria, or the fields on which you've joined tables are not the same type
of data (e.g., integer numbers are not the same type as Double numbers).

Start out by making a copy of your query and, in the copy, taking one thing
out at a time until the query either works or is empty!

Post the SQL statement of your query.

Good luck

Jeff Boyce
<Access MVP>
 
Jeff, yer a life saver!! Finally emptied the date CRITERIA field of all the
dates I was trying to input and was able to RUN QUERY. Finished the database
AND the Unit. Thanks heaps!!
 
Back
Top