how to include or exclude based on a check box

[Milothicus]

I'm working on a Purchase Order system, and on my search page i have a check box that selects wether or not completed orders will be included. I have a 'required' column that lists the number of items outstanding on each order. i need an if statement that determines wether the query selects all the records, or just the ones with required > 0.

i've tried a few things but can't get it to work.

i tried a search but couldn't find which words to search for.

 

[ColinEssex]

I'm working on a vaguely similar thing.

What I did was to have a table of orders detail - orderNo, OrderDate etc and a table of items issued for the orders. So a customer can have many orders and an order can have many items issued on it.

Then in the issues table, if its a part order (Quantity ordered > Quantity sent) then a tick is automatically put against that item to indicate its not fulfilled yet.

Then I have a form where the user selects an item to fulfill a part order then the user goes to a form to see all outstanding part orders (with the tick) and the user can then prioritise whichever one is most urgent. When they fulfill the missing items, the tick is removed.

Col

 

[Milothicus]

right....similar system different problem. instead of a tick box for partial deliveries, i have a column that lists the number of items received. this way if the # received = # ordered, that item (within that order) is complete. I have a report that lists which orders are complete and which are incomplete, and it lists which items are missing, if any. the underlying query calculates # required (#ordered-#received) and if any #required within an order is >0, it's incomplete.

all that works fine. it's just that in my search, i need to calculate #required, and then each time the search is run, i need to either include all records, or only records that have #required>0, depending on wether or not the user has selected the 'include completed orders' check box.