Query Counter

[Scarlet via AccessMonster.com]

Hello All,

Please help me put together this simple enough query. The fields are "region",

"period", "yusage", and "arrival". My query as of right now returns all the
information that I need, though I am not sure what I need to do to properly
format it.

For example here are three sample records....

South East, 2, 2005, 1/12/2006
South East, 2, 2005, 1/15/2006
South East 2, 2005, 1/12/2006

Once the counter runs it produces (the dates are grouped, and I would like
them combined)...

South East, 2, 2005, 2
South East, 2, 2005, 1

How do I produce....

South East, 2, 2005, 3

Thanks so much!!

 

[Stefan Hoffmann]

hi,

Please help me put together this simple enough query. The fields are "region",
"period", "yusage", and "arrival". My query as of right now returns all the
information that I need, though I am not sure what I need to do to properly
format it.

For example here are three sample records....

South East, 2, 2005, 1/12/2006
South East, 2, 2005, 1/15/2006
South East 2, 2005, 1/12/2006

Once the counter runs it produces (the dates are grouped, and I would like
them combined)...

South East, 2, 2005, 2
South East, 2, 2005, 1

How do I produce....

South East, 2, 2005, 3

Thanks so much!!

SELECT region, period, yusage, COUNT(*)
FROM YourTable
GROUP BY region, period, yusage


mfG
--> stefan <--

 

[Scarlet via AccessMonster.com]

Thanks got it working!

hi,

Please help me put together this simple enough query. The fields are "region",
"period", "yusage", and "arrival". My query as of right now returns all the

[quoted text clipped - 18 lines]

Thanks so much!!

SELECT region, period, yusage, COUNT(*)
FROM YourTable
GROUP BY region, period, yusage

mfG
--> stefan <--