Data not pulling through to query

[halnurse]

I am trying to run a query that shows material that is on Back Order. The Back Order expression takes quantity ordered from one table and quantity received from another table and subtracts the two. The problem is that the quantity received his entered when a packing slip and material comes in and not before. In this from the material is selected from a drop down and then the quantity received is filled out following the selection. If the material has not been received yet it doesn't come through on the the query. I have a iif function that sets a 0 for any null values in received quantity but that didn't seem to help.

Is there a way to create an option in the material drop down that pre-selects all of the items in the drop down so they are all selected or is there a better way to do this.

Thanks in advance!!

[Micron]

You are using form control references to provide criteria to the query? Then on a copy of the query, test hard coded values for everything and see what you get using criteria that you are sure should work. If you get no results, there is likely something wrong with your join(s) or the basic query itself. In these situations, it's often best to start with the minimum (even if that's one table) and individually test criteria portions on each table as separate queries before joining the the tables in one. Test as you go.

If that approach doesn't work, posting your sql might help, but it's often difficult to pinpoint the problem without understanding the data or relationships,