create a Query where I can get the total of events with the same Style.

  • Thread starter Thread starter Hector Codoceo
  • Start date Start date
H

Hector Codoceo

Hello,
I need help with the following problem, please!

I have a table called "JOURNALS" with two fields "Journal"
and "Style". I need to create a Query where I can get the
total of Journals with the same Style.
- It's 1 Style per journal.
- Many Journals with the same Style.
- Both data type are Text

Style Journals
---------------
acs 11 <-----there are 11 journals with the acs style

How can I do that?
Please, Help.
Thanks.
Hector
 
-----Original Message-----
Hello,
I need help with the following problem, please!

I have a table called "JOURNALS" with two fields "Journal"
and "Style". I need to create a Query where I can get the
total of Journals with the same Style.
- It's 1 Style per journal.
- Many Journals with the same Style.
- Both data type are Text

Style Journals
---------------
acs 11 <-----there are 11 journals with the acs style

How can I do that?
Please, Help.
Thanks.
Hector
. Try this.
SELECT [tbl journals].Style, Count([tbl
Click to expand...
journals].Journal) AS CountOfJournal
FROM [tbl journals]
GROUP BY [tbl journals].Style
HAVING ((([tbl journals].Style)="ACS"));
 
Back
Top