Dear All,
Having difficulty getting my head round this - I cant even build it using QBE.
I am trying to return two aggregate columns in a query based on one field. ie
If the table contains fields [IDNumber] & [Award] I want the query to return 3 columns: IDNumber, COUNT(AWARD) As 'Count of Nomination', COUNT(AWARD) As 'Count of Win'. This would be where the [Award] field contains either 'Nomination' or 'Winner'.
Any help would be much appreciated.
Regards
Weasel