A
Anthony Strickland
Guest
I have built a query that has most of my fields from a table named "Sales Orders" within it. One of the fields within the "Sales Orders" table is "Invoice #" and I would like to use this field to basically close the order. What I mean is that when the Invoice # gets entered into this field via a form, I would like to be able to run a separate report that would search the "Invoice field" for null values and produce a report that shows me these records or what I will call "Open Orders" I know how to do everything I just said, but I do not know what the expression is that I should input into the "Invoice Field" criteria section of my query that will be used within the report.
Any help would be appreciated.
Any help would be appreciated.
