help with a criteria

[dmhayes]

I have created a database with parts in it... to find every part that needs to be ordered.

table
partid
partnumber
partdesc
minqty
maxqty

in a querry i put for the criteria > ????? under the minqty

should this work..

 

[KenReay]

Hi

You say

in a querry i put for the criteria > ????? under the minqty

try

for the criteria > [Min Quantity]

when you run your query, this will cause a pop up box to appear where you can enter a value (eg say 10), this will cause your query to seelct all rows where minqty column is greater than (say) 10.

I suspect you want < [Min Quantity]



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK