-
less than
Hi,
I'm thinking this is quite simple, but am fairly new to access and still learning...!
I have a table with a list of products including 2 columns titled 'quantity' and 'minimum quantity'. I would like to create a query whereby it will show all lines that have a quantity that is less than the minumum quantity.
I can create a query which shows lines that have a quantity less than 'x' amount, but different products will have different minimum quantities.
Any ideas?
Thanks.
-
Add a new column to the query and in the field type something like this:
LessThan: IIf([quantity]<[minimum quantity],1,0)
Now in the criteria for that feild put 1
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules