Sum of fields

S

Scott

I am currently trying to get a sum happening in a query format. My dilemma is
this, I have a tabel with bill information in it and each bill has a BillID.
There may then be multiple Bill Lines for each BillID, what I am wanting is
to display only the total of the bill lines for each BillID. Each Bill line
has a separate BillLineID. Probably an easy answer for this but I am a bit
rusty..

Cheers,

Scotty
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sums in query 1
Look Up Formula With Veried Search Range 2
Page numbering with Merged Document and IF statements 1
Copy previous record into form field 0
Change Form's Recordsource with SQL Statement? 0
one field require more than on text box 10
Problem Adding a field based on expression 1
Data Type Mismatch in Criteria Expression 2

Top