Missing Operator error

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

AccessXP

I'm getting a missing operator in query error when I try
to run it in a replicated version. The Origional runs
fine, but the replicas all fail.

The criteria is if a checkbox is checked or not. I have
in criteria "=-1" for that field. When I save it and
reopen it, it has changed to "-1". Is this the problem?
If ti is, what can I do about it if it's doing it on it's
own? It only causes an error in the replicated versions.

I'm very new to Access, so I really could use the help

Thanks.....Jim
 
Dear Jim:

In the Query Design Grid, it is understood that a criteria uses "equals"
when no other compariason operator is shown. So, to have it drop the "="
doesn't sound like a problem. That's just normal behavior.

If you will go to the SQL design view of the query you can copy the text of
the query from there and post it here. We can try to work from that to find
your problem.
 
OK, here it is (except for all of the fiels)

SELECT [then a bunch of fields]
FROM[Record of Conversation]
WHERE ((([Record of Conversation].PrintNow)=-1));

PrintNow is a checkbox that the macro checks to see what
record to print. It places a checkmark in that field, runs
the query, prints the report then unchecks the checkbox.

Remember it works fine except in the replicas.
 
Back
Top