Totals

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

I have a field called codes, another field called TAT. Is it possible to get
the count of the total amount of the same code with the same TAT?
EX
Code TAT
013 0
013 1
013 1
013 2
013 2
code TAT Total
end result would be 013 0 1
013 1 2
013 2 2
 
LG,
Use a Totals query. (in Query Design... View/Totals)
Group on
Code: 
 and Group on [TAT]
The [Total] would be...
Count(Code)
That would yield just what you indicated.
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Create a query that includes Code, TAT and a second TAT. Click the Sigma
(looks like capital E) button in the menu at the top of the screen to change
the qyery to a Totals query. Under the second TAT, change Group By to Count.

Steve
(e-mail address removed)
 
Sure. Create a query with the Codes field and the TAT field. Bring down the
TAT field twice. Run it to make sure you get the expected results.

Go back to design view and change it to a Totals query. If Access 2003 or
older, go to View on the menu and checkmark Totals.

Make sure that Codes field has Group By under it. The first TAT field should
also be Group By. Change the second TAT field to Count.

Run it.
 
Arno,

Please *only* carry out your promise to chase Steve when he replies offering
services for a fee. He didn't do that in this case, so your chastising him in
this thread is entirely inappropriate.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
Tom Wickerath said:
Arno,

I cannot killfile you, because I use the web interface to access this
newsgroup. Over 75% of the people who post questions to this newsgroup use
the web interface, so they cannot killfile you either.

http://www.microsoft.com/office/com...32be13-facc-46c9-933b-357d5397eb39&sloc=en-us


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
Click to expand...

Hi Tom,

Where does it say that 'over 75% of the people use the web interface' ???
If so, than killfiling is not an option indeed for a lot of people...

Arno R
 
Hi Arno,

These statistics are not given anywhere; they are approximate stats, which
you can determine by opening MPA here:

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.access

Count the number of posts shown on page 1 that display a white question mark
within a brown circle (these questions were posted via the web interface).
Then count the total number of posts on the same page.

At 12:43 AM Pacific Time, on 2/9/2010, I count the following for page 1:

Web Interface: 14 posts
Total Posts: 23 posts

% Web Interface = 60.9 % (for this particular snapshot in time)

Okay, so maybe I was a bit too generous with my "over 75%" statement, but
the number of people who cannot kill file an individual is still quite
significant.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
Back
Top