Form Report and Query Problem

  • Thread starter Thread starter Cyndy
  • Start date Start date
C

Cyndy

I have changed the Order Status field on my Form Orders
form to allow selection for Open,Close,Cancel. The Open
and close works fine , but the cancel doesn't. This to
give the user a chance to Cancel a order that has been
saved to remove it from the report before it is sent to
the supplier. I added the Order Status to the query for
the report and placed Not = "Cancel". The first Time I ran
the report the item was cleared. The next few times I ran
the report item didn't clear. When I looked at the query
<>"Cancel" appeared. What expression should I use in the
query to prevent the item from showing on the report.

Thanks
 
Cyndy,

<>"Cancel" Should be correct. The query corrected your Not = "Cancel" which
is not standard syntax.

Gary Miller
 
Back
Top