ADDING Amount to get ONE TOTAL~!

  • Thread starter Thread starter Vince
  • Start date Start date
V

Vince

Hello,

After I create a query to select records based on date
and location, how to I ADD the [Amount] together to get
ONE total?

Please assist!!!

Vince
 
Make the query that you created into a Totals query (click the Greek letter
sigma [looks like a crooked E] in the toolbar) and select the Sum option
under the field Amount.
 
Hi Doesn't work....

THX but I kinda tried the SUM approach...

I just want ONE total it's still showing separte records
that I queried!

Please assist

THX.
 
SORRY I tried again with less fields and it WORKED....

IS there a max amount of fields I can choose?

Please advise

Vince
-----Original Message-----
Make the query that you created into a Totals query (click the Greek letter
sigma [looks like a crooked E] in the toolbar) and select the Sum option
under the field Amount.

--
Ken Snell
<MS ACCESS MVP>

Hello,

After I create a query to select records based on date
and location, how to I ADD the [Amount] together to get
ONE total?

Please assist!!!

Vince
Click to expand...


.
Click to expand...
 
VINCE said:
Hi Doesn't work....

THX but I kinda tried the SUM approach...

I just want ONE total it's still showing separte records
that I queried!
Click to expand...

Then your query should have exactly one field in it.

GrandTotal: Sum(YourField)
 
Back
Top