Search results

I have put together a fairly simple stock control database thanks to the help of an Access teaching book I have. I'm on the final hurdle, and that is creating Sales reports so the EndUser ( this is a school project ) can view past sales by week or month. Here is my transactions table: Here...

Have a fairly simple scenario I hope someone can help me carry out. I am focussing on two tables: Sales and Stock Stock contains information on each product and includes a 'currentStock' field which is decremented with each sale. Sales records each sale with date and stock id. I want one...

Hello all, I have an Access database for a project I'm currently working on. It's a simple stock control system which records sales and the level of stock. How can I set up a form that when you click a button, two queries are run? I want to add a record to the 'Sales' table but also modify the...