Search results

I figured out a way to do this, just eliminating the two queries and creating a new one with an if statement for producing the date.

I created a table, this command deleted 863 of 912, way too many

I tried that command, but its removing to many items. I have 456 items in each query, but the union is only display 324

I want to delete the duplicate item which has a date in the future, not just the item in query2

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...