Search results

Hi there, Is it possible to subtotal in access like you can in excel? I am trying to write a query that includes a list of invoice numbers, item quantities to produce a total per invoice but the item and quantity number is repeated. I can do this in a report however interested to see if I...

I am an access n00b.... so please bear with me! :D I have a table that has some sales data: for a given invoice, there are a number of units sold, and a cost per unit. One invoice can have a number of different items on it. Eg: Invoice UnitID Quantity_sold UnitPrice 1001...