Calculate Totals

[travismp]

Need help with calculating totals.

I have a rep titled “rep_Billing” attached in zip format. There are the "Clients" that I bill every 2 weeks. My accounting dept needs some totals:

Total number of tests at $34
Total number of tests at $6
Total number of tests at $5
Total number of tests at $4

Then a grand total. Each client report will have these numbers. The Report is completely built except for the totals. Any help would be appreciated. Thank you.

T

 

[llkhoutx]

Sum the field to be totaled in the Page and Report footer.

 

[travismp]

I know how to get the grand total, but how do I get an individual total. There is one field titled "Cost" with multiple amounts. I need those separated by unique numbers in that field, then totaled.

 

[llkhoutx]

You problem is not clear from for zip or postings.

how do I get an individual total. There is one field titled "Cost" with multiple amounts. I need those separated by unique numbers in that field, then totaled.

I have no idea whbat you want or where. Please clarify.

 

[Ukraine82]

Take a look at the attachment I posted on this link.

http://www.access-programmers.co.uk/forums/showthread.php?t=77547

hth,

Michael

 

[travismp]

I read this post before. I am needing one step further...

you have "=Sum([ContractAmt])"

What I need is for it to give me a total of pricing first... take your "Quirk" family. I would want the report to say

1 Test at $500.00
1 Test at $550.00

Total $1150.00

If there was a third test at $500 it would then say:

2 Tests at $500.00
1 Test at $550.00

Total $1650.00

See what I am getting at?

 

[Ukraine82]

From what I'm getting is that you want to break it down by the amount?

Test 1 = 500$
Test 1 = 600$

If you get another 500$ that will be Test 2 = 1000$
If you get another 600$ that will be Test 2 = 1200$

Right?

Take a look at the attachment. If you look at the client/contract report you will see that I broke it down by Clients Name.. You want it break it down by Amount..Take a look at the ClientsName Header and ClientName Footer. Let say your field name for dollar amount is [DollarAmount]all you have to is make DollarAmount Header and DollarAmount Footer.

If you're lost try posting your database so I can take a look at it.

hth,

Michael

 

[travismp]

I want:

Client 1 has 4 tests....

Test 1 = $5
Test 2 = $5
Test 3 = $5
Test 4 = $10

I want the report to show:

Client 1
3 tests at $5
1 Test at $10
Total = 25


I attached my db in the original post. The report is completely made except for the totals. I know how to do a grand total of all tests, but do not know how to get a (Count) on the individual numbers.

Thank you for the help so far.

 

[Ukraine82]

Take a look at the attachment I made for crosstab query. I'm sorry I don't have time to make some adjustment, but I managed to get a crosstab query (tbl_AMROTABLE_Crosstab) of what you looking for. Maybe you can play around with it.

Good Luck,

Michael

 

[travismp]

New File

thanks for the help, but that did not help me at all... I figured out a few things on my own... see attached file...

My field math shows: =Sum([COST]="34.00")

I did this for each possible cost, but for some reason it shows a negative. If i had three tests at $34.00. The result shown on the report is:

Tests at $34.00 = -3

when it should show

Tests at $34.00 = 3

Is it something in my script???

You can download my new file if it helps. Thanks

 

[travismp]

This is great... it will take me some time... to work out all the bugs, i am not good, but it sounds like it will work. I will try this later today.

Thanks to both of you for all the help.

Travis

 

[travismp]

=Sum(IIf(YourAmt = 6, 1, 0))

Where does my [COST] field go into this equation?