Query Error

[Cined]

Hello,

I'm getting the following error when using this query:


Error:

"You tried to execute a query that does not include the specified expression 'Type' as part of an aggregate function."

Any ideas?

Thanks.

[pbaldy]

Does this do what you want?

SELECT DISTINCT [Type], COUNT([Type]) AS Total
FROM [Sale Property]
GROUP BY [Type]

[Cined]

Does this do what you want?

SELECT DISTINCT [Type], COUNT([Type]) AS Total
FROM [Sale Property]
GROUP BY [Type]

It does indeed

Thanks for the help.

[pbaldy]

Happy to help.