Having trouble with Queries and criteria

  • Thread starter Thread starter Kendra
  • Start date Start date
K

Kendra

I did a bunch of queries and thought they were all going well and I was doing
them right but it turns out that I wasn't.

A couple of them work but most do not. When I go to open them it says "Data
mismatch in criteria expression"

This is for an assignment that is due at midnight so any help would be
appreciated.

Thanks.
 
I did a bunch of queries and thought they were all going well and I was doing
them right but it turns out that I wasn't.

A couple of them work but most do not. When I go to open them it says "Data
mismatch in criteria expression"

This is for an assignment that is due at midnight so any help would be
appreciated.

Thanks.
Click to expand...

Please help us to help you, Kendra. All I can say at the moment is "there is a
mistake in your query, probably having to do with using a Text criterion on a
Number field or vice versa".

Please open one of the queries causing the error, and select View... SQL. Post
the SQL text here. It would help a lot if you indicate the datatypes of the
relevant fields, especially if you have a <yuck, PTOOIE!!> Lookup Field.
 
Back
Top