Copying filter results on a search form into a table or query (1 Viewer)

[mounty76]

Thank you.....I might be back in touch!! haha

 

[mounty76]

Hello!! I have one more thing you might be able to help me with!!

In my table each record has a field called code, they are something like:

1.01 XXX
1.02 AAAA
1.03 BBB
2.01 OOOO
2.01 QQQQ
3.01 KKKKKK
3.02 FFFFF

Also in each record is an invoice value

Is it possible to group the codes together and then sum the total of the invoices for that code group? Something like

1 $10000 (the sum of the invoice column for all the records with 1.**)
2 $30000 (the sum of the invoice column for all the records with 2.**)
3 $2500 (the sum of the invoice column for all the records with 3.**)

Hope that makes sense!

 

[mounty76]

I know how to do it for individual groups but wanted ideally all the groups in one query

 

[theDBguy]

I know how to do it for individual groups but wanted ideally all the groups in one query

Have you tried using a Totals query?