Search results

I have two queries, qFabricate01 and qFabricate02, with the only difference is in the field labeled Fabricate. In q01 I am using the date value from the field Delivery and q02 the date value from the field PUDATE. What I would like to do is combine the two, removing the duplicate row, of the...

I have three fields calculating info in my query. The end result I would like to see is the Comp Reqd field to be greater 0. When I put the criteria for this field to >=0, then run the query, the system is asking me to input values for Comp Qty Due, CompInv As Assy, and Comp Inv. I would...