Please help with this query ASAP

[SammyConfirmed]

Need to create this query

[Micron]

change workoutname from group by to count; change 3 or 4 or 5 to >3 (what you have in the query doesn't match what your posted text says. You might have to change Date from group by to "expression" Date is a bad name for a field. See http://allenbrowne.com/AppIssueBadWord.html
I've never seen Like with wildcards for date values. Maybe use Datepart or Year function, but I'd change the date field name first.

[CJ_London]

dates are stored as numbers, not text. Your like criteria may work but the usual way would be to use the year function

year(Date)=2017

Also note that Date is a reserved word - it means today so using it as a field name can cause problems since sql won't know whether you are using Date the function or Date the field (although square brackets he to differentiate). Recommend changing it to something more meaningful such as workoutDate or classDate

not sure what you need help with for the workout name column - just change the group by to count

[SammyConfirmed]

It says 1 for the count, which is wrong. It must count all unique values (all types of workoutnames) and display the number of how many times each workout has been performed.

[isladogs]

If you want the total count of each type of workout, remove the date column.
Otherwise it will tell you how many of each type occurred on each date which seems to be one in all cases.

[SammyConfirmed]

Yeah it works like that, but the query requires me to only list those workouts which have been done in 2017. What do I do to get that? Thanks btw!

[Micron]

If you want the total count of each type of workout, remove the date column.

That is why I suggested removing the grouping in favour of "expression". Not that I'm guaranteeing it would produce the desired result if done so, but I could see it would not without trying at least.

Or if it's needed for criteria, don't remove it - uncheck it.

[SammyConfirmed]

That is why I suggested removing the grouping in favour of "expression". Not that I'm guaranteeing it would produce the desired result if done so, but I could see it would not without trying at least.

Or if it's needed for criteria, don't remove it - uncheck it.

Doesn't help.

[CJ_London]

just realised I have been looking at this wrong

you group by workout name

you count class ID

you change the date field from group by to where

you change the workoutdifficulty from group by to where

if you want the count to be split by difficulty, add workout difficulty a second time and group be that

[SammyConfirmed]

just realised I have been looking at this wrong

you group by workout name

you count class ID

you change the date field from group by to where

you change the workoutdifficulty from group by to where

if you want the count to be split by difficulty, add workout difficulty a second time and group be that

It worked!!! Thanks!!