Search results

  1. M

    Create Sales report from Transactions table

    Anyone able to help with this? Sadly I have little time to get this completed :(
  2. M

    Create Sales report from Transactions table

    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...
  3. M

    How would I do this? - Stock Control

    would you mind linking me to one of these threads please? I've tried searching with little luck.
  4. M

    How would I do this? - Stock Control

    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...
  5. M

    One form field serve two jobs?

    Darn, so could you recommend a method of recording sales and updating stock levels as one process?
  6. M

    One form field serve two jobs?

    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...
Back
Top Bottom