adding totals in rows

[XKIMBAL]

I have a query that shows the Product# on books, how we sold the book, and a count of how many sales. My manager wants 3 types of sales to be added together, is there a way to do this directly in a query? Adding up several rows of distinct information and placing the sum on one of the count fields?

I don't want it in a report because I need to use the info for further querying.

Thanx...

 

[Howlsta]

Do a totals query. Create a new query and select totals in the View menu. A totals field is added to the query, anything you want to do can be entered into the total field i.e. count, sum, max, min etc

HTH

Rich