Sums in query

[Scott]

I currently am trying to sum records from a table. The situation is thus, I
have a bills table that holds bill information. Each Bill has a BillID and
may also multiple Bill Lines (fields that have their own BillLineID). What I
want to do is to get a sum of the Bill Lines for every BillID on a given day?
Thoughts anyone? Probably a simple answer but smy skills have gotten rusty
through lack of use.

Cheers,

Scotty

 

[tina]

link the two tables in a query, with an INNER JOIN (the default join). drag
the BillID, the date field, and the amount field into the query grid. turn
the query into a Totals query (View | Totals on the menu bar), grouping by
the BillID and the date field, and summing the amount field.

hth