calculating On Hand Quantity

[hbm001]

Hi,

I'm having some matching criteria issue for the re-order point query. Could you please look at query2 in the attached file.

thank you so much for helping out.



Testing Database1_new1.zip

[pbaldy]

The error is because of the text values in the stock field. It should be a numeric field and shouldn't have text values in it if you want to do calculations with it.

[hbm001]

Hi Paul,

I changed the field type, however I am now encountering another problem. It is giving me about 20 entries per title, and when I try to group the title it doesn't work. Not sure where all those entries are coming from. Can you please have a look and help me out with where the problem lies.


Testing Database1_new1.zip

[pbaldy]

You're getting the multiple entries because you don't have a join between the table and the query. Without a join you get a Cartesian product.