Differents totals for each year of birth within a Field.

[Joe T]

I use MS Office 2007 Access. I have a Table with a Field Data type: Number,
with an Input Mask of: 0000 for the Birth Year of each of our member; over
1,000 members (records). In a Query if possible I would like to have a total
records for each year of birth. What is the best way to do it? Thankyou.

 

[Tom Wickerath]

Hi Joe,

Create a query and flip to SQL view. Use the following SQL statement, where
[FieldName] and [YourTableName] are the names of the field and table,
respectively:

SELECT [FieldName], Count([FieldName]) AS NumMembers
FROM [YourTableName]
GROUP BY [FieldName]
ORDER BY [FieldName]



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

 

[Joe T]

Good morning Tom,

I tried it and it works: EXACTLY what I was looking for. Thankyou for your
time.

Joe T

Hi Joe,

Create a query and flip to SQL view. Use the following SQL statement, where
[FieldName] and [YourTableName] are the names of the field and table,
respectively:

SELECT [FieldName], Count([FieldName]) AS NumMembers
FROM [YourTableName]
GROUP BY [FieldName]
ORDER BY [FieldName]



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

I use MS Office 2007 Access. I have a Table with a Field Data type: Number,
with an Input Mask of: 0000 for the Birth Year of each of our member; over
1,000 members (records). In a Query if possible I would like to have a total
records for each year of birth. What is the best way to do it? Thankyou.

 

[Tom Wickerath]

Glad to help!


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