Trying to Count Values in Query

[ijo68]

Hello All , Can anyonr tell me what I'm doing wrong here. I'm trying to count how many students based on the Criteria ( > = 12) from the age field.. In other words how many students are 12 and older ..

Any help will me much appreciated .. Thank You

[MsAxes]

If the age is a string, you might need >= "12" - what results are you getting when you run the query?

[June7]

You have >= 12 on the count, not age.

[Welshgasman]

Put the criteria into the first column?
I believe you are trying to count more than 12 in the actual count?

Showing the sql would confirm?

[mike60smart]

Hi
It does look like you have set the joins between tables wrong.

Also, I would suggest that the CheckIn field should be in the Attendance table.

Can you upload the actual database?

[Micron]

If the age is a string, you might need >= "12"

IIRC, Access will automatically wrap criteria in quotes when it 'sees' that it is a text field. That's one way you'd know. Another is that in queries and tables, text is left aligned, numbers are right aligned. You can alter this in tables but not in query results.