Help with

[HFSL]

I have a table containing various product items and pre-set default levels that are specific to different departments at my place of work (Table: Reference, Group Name, Product Code, Default Level).

What I am aiming to do is to create another table/form which will lookup a group name and show any products that have a re-order level set for that group. I have managed to do this using queries. However I also need to be able to record, for each product within each group, how many items are remaining on a particular date and create a record for this. This is where I am getting stuck every time!

The final aim is to be able to know how much stock of each item, for each Group, has been used and how many of each item needs to be ordered to get to return stock levels back to the default level. With this information I aim to create graphical reports over different time intervals which include the date, group, default level + remaining items on that date.

Thanks for any help you can offer in advance!

 

[jdegeorge]

Take the queries that work and change them frome SELECT to APPEND to your other table. Create another query that does your totaling as an UPDATE query to the new table to update that record's remaining totals. Hope this helps.

Jim DeGeorge