Help with an update query

[workwork]

I'd like to create a query where when a book is ordered, the book quantity in a different table is updated and subtracts the quantity ordered.

I'd also like another query where, when a books quantity falls below 5, the book title, with the reorder level is sent to either a new table called something like tblReorder or somewhere else where it can be picked up in a report.

I'm happy to do vba and sql.

Can someone help me?

I have very basic knowledge of access so please explain as if talking to an idiot.

 

[AlexHedley]

You could create an UPDATE Query to change the number in a Table based on its ID.

http://www.599cd.com/tips/access/update-query/

http://office.microsoft.com/en-gb/access-help/update-data-by-using-a-query-HA010076527.aspx#BM4

UPDATE table
SET newvalue
WHERE criteria;

- - -

For the second issue I'd just create a Query with a CRITERIA.

SELECT * FROM table WHERE field < 5

 

[workwork]

Thank you for your help!

I've managed the first but I'm still struggling with the second.

So I've used tblBook and have brought down the BookID, Title, Author, Quantity, ReorderLevel, ReorderQuantity. I basically want it so that when the Quantity is below the ReorderLevel, the Title, Author and Reorder Quantity are sent to tblReorder or something.

 

[jdraw]

To get a list of the "Books" that are below their reorder point, I agree with Alex.

SELECT the fields you want FROM YourTableName
Where Quantity < ReOrderLevel