Query Criteria

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

Guest

I put "In-Service Date" without the " " in the criteria box and I got the
message "The In operator you entered requires parenthesis". I tried a
variation of parenthesis and nothing works. What should I type to get
acceptance for this filter request? I can't use I* or *Date because there
are other data that starts with I and ends with Date, I need to pick up cells
that contain only In-Service Date.
 
When expressing a field you need to use brackets like this ---
[In-Service Date]

It seems to be In-Service Date field would not be criteria for any field but
would have criteria applied to it.

Post your query SQL for examination.
 
Hi

You need to put the " " back in so the criteria box has the following in it

"In-Service Date"

Regards

Andy Hull
 
Back
Top