Simple query Just new to this

[j10reeve]

Hello i have a simple query that i need to happen.

All it is, is i want only to display the stock that needs to be ordered.

like

( if [stock level] < [Usual Stock Level], Then i really need it to display in a report or table or something.)
i Think i am on the right lines but really not sure the 'Stock Level' and ' Usual Stock Level' are then field names in my database.

Hope some one can help, Please

Thank you

Jordan

 

[Trevor G]

Hello i have a simple query that i need to happen.

All it is, is i want only to display the stock that needs to be ordered.

like

( if [stock level] < [Usual Stock Level], Then i really need it to display in a report or table or something.)
i Think i am on the right lines but really not sure the 'Stock Level' and ' Usual Stock Level' are then field names in my database.

Hope some one can help, Please

Thank you

Jordan

Jordan welcome to the Forum,

Look to create a query that is based on your table, then select the Stock Level Field in the bottom area of the window you could set some criteria like if the value goes below 10 then look to re order. You can then either run the query or create a report if needed.