Search results

For anyone who stumbles across this code (like I did) please note that the code, as written will not kill the timer! To stop a timer via KillTimer, you need to pass it the hWnd that it was created with. i.e. in this particular case: 'Stop timer Public Sub Stopit() If TimerID <> -1 Then...

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

Thanks very much - I created another query to sum the totals as suggested, and it worked great.

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