Search results

  1. E

    query to give stock levels?

    Hi all, I have the following query (Access 2010): SELECT tblSales.ProductID, Sum(tblSales.QuantSold) AS SumOfQuantSold, Sum(tblSales.QuantBought) AS SumOfQuantBought FROM tblSales GROUP BY tblSales.ProductID;This produces the following result: ProductID SumOfQuantSold SumOfQuantBought...
  2. E

    Question Access newbie

    Hi all, Some advice please... Firstly, I am a complete novice when it comes to Access. I am looking to make an attendance recording system for my club. My feeling is as follows:- 1: Membership table holding membership number, name, address etc. 2: Attendance table holding membership number...
Back
Top Bottom