Payment of club subscriptions can be in the form of different 'Payment Types'. I need to create a query upon which to base a pie chart which illustrates the different payment types as a percentage of the whole membership but am struggling with the expression which returns a count of the different payment types. 'Payment Types' are held in a two-column table (where the fields are 'Payment Type' and 'Payment Type ID') which feeds a drop-down list comprising 'Payment Types' within a 'Payments' table. Relevant data are stored as 'Payment Type ID' within the 'Payments' table which also holds a 'Member ID' field to link members with payment types. Can anyone come up with an expression to count the number of different payment types? I would really appreciate the help.