Adding multiple purchases

[Josh Albers]

We have a data base that is used in selling books. we have a purchases table
that contains multiple purchases from multiple buyers. i.e. one buyer buys
something on 10/31 and on 11/5 so obviously there is other purchases between
that. we are stumped on what we would do. we need a formula for the query
to get the total amount of purchases for the individual userid.

 

[Duane Hookom]

Create a totals query.
SELECT Sum([PurchaseAmount])
FROM tblBookSales
WHERE UserID = x;

 

[Tom van Stiphout]

On Thu, 6 Nov 2008 21:26:00 -0800, Josh Albers <Josh
(e-mail address removed)> wrote:

You wrote: "so obviously there is other purchases between that."
I'm assuming you meant "...there are ...". That's not at all obvious
to me, from the outside looking in. What's so strange about someone
ordering books about once a week?

The word "amount" in the US language is sometimes abused. Do you mean
"the dollar amount of the sum of purchases", or do you mean " the
total number of books purchased"?

It may help if you would describe to us the tables involved.

-Tom.
Microsoft Access MVP