less than

[Maverick1501]

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.

[SoftwareMatters]

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