Differents totals for each year of birth within a Field.

  • Thread starter Thread starter Joe T
  • Start date Start date
J

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.
 
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/
__________________________________________
 
Good morning Tom,

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

Joe T


Tom Wickerath said:
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 said:
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.
Click to expand...
Click to expand...
 
Back
Top