Replacing COUNT(DISTINCT column) in an Access 03 query

M

Mitch_Leonard

Joined
Nov 17, 2008
Messages
1
Reaction score
0
Hi All,

I have the following query that I wish to run on an Access '03 db:

SELECT SUM(Charged_Amt) / COUNT(DISTINCT Cust_ID)
FROM Table08;

Charged_Amt and Cust_ID are columns in Table08. Basically I want the total spend divided by the number of distinct customers.

Since COUNT(DISTINCT column_name) is not recognised in Access I was hoping someone could suggest an alternative. I have tried using nested queries but my SQL is very basic and I keep getting errors.

Any help would be greatly appreciated,

Mitch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Distint count In Query 0
Access MS Access Help with Select Distinct(count field) 0
COUNT and DISTINCT in Access 3
how do i perform a Count(Distinct) query for 2 different column va 1
Counting Distinct Entries 2
COUNT DISTINCT ? 5
COUNT DISTINCT problem 6
Access SQL Help 1

Top