How to prepare report listing bikes that r low in stock and need to be ordered?

[sharon pandher]

prepare report listing bikes that r low in stock and need to be ordered. Report should also provide supplier info.

2 tables: supplier table and product table.
supplier table fields: supplier#, company name, id no.
product table: id no, product name, product category, quantity on hand, reorder level.

[beacon]

Hi Sharon,

Create a query and add all the fields you want from your two tables. Once you've added all the fields you want, add the following expression:

'True = Reorder, False = Don't reorder
IIf([quantity on hand] <= [reorder level), True, False)
 

Then create a report that is based on this query. You could add some conditional formatting to highlight the row if the product needs to be reordered (True on the expression field you created in the query).

beacon

[malcolmk]

Is this a homework question? I seem to remember helping you with a prog to report average times hotel rooms of different grades were occupied! Long way from working in a bike shop!
Just wondering.

[sharon pandher]

Hi Malcolm,

you did help me with a prog. this question is part of homework, i have to create 10 reports and i cant seem to figure this one out.