Calculations in a form

[UT227]

I'm trying to make an ammunition DB where I can calculate the cost of qualifying. I have made a query where I have records with rounds out and rounds in. The query calculates the cost of each record using this: TotalCost: ([RoundsOut]-[RoundsIn])*[AmmoCost]. I'm trying to create a form which with list the caliber once and then total up the AmmoCost. Does anyone know how to do this?

[UT227]

Correction on this. I want the sum of TotalCost, not AmmoCost.

[pbaldy]

Sounds like you need to change Group By to Sum on the middle 3 fields.

[John_G]

In the Totals line of the query definition, change Group By to Sum for TotalCost, and change Group By to Where for AmmoNote.

[John_G]

Sounds like you need to change Group By to Sum on the middle 3 fields.

Thanks, Paul - I missed that

[pbaldy]

No problemo!

[UT227]

That worked perfectly. Thanks.

[pbaldy]

Happy to help!