Recent content by edenforge

Hi Paul, Thanks for that. is there a way to get somthing like this to display on a form? ProductID QuantOnHand widget1 98 widget2 380 widget3 95 Regards Bob

Hi Paul Thanks for the reply. As I said, I am very much an Access NOVICE. Can you expand on the above: a: how to do it on the form b: how to add the line above to a query Many thanks Bob

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

did you find the answer to this? Bob

OK thanks for that

Hi Bob Thanks for the reply. As I said I am a complete newbie with Access, so a further question if I may: To access a member record I am presuming the best way is to enter the membership numbers (in the form of "NIC01") into a field, if I was looking for a record in Excel I would use VLOOKUP...

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