Distinct Count in Access

[shelby55]

Hi

I have an Excel worksheet that I am querying from an Access query for. My Access database is of patients, one line per patient (so data isn't aggregate).

I want to show average number of patients per arrival hour. Arrival hour is already a field in the database.

Any assistance greatly appreciated - thanks.

 

[SkipVought]

Hi,

My Access database is of patients, one line per patient (so data isn't aggregate).

A well designed database/table generally will NOT have data aggregations. Aggregations occur when you perform a query.

Since you have one patient per row...

Select Count(*)/[Arrival Hour]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[shelby55]

Hi Skip

Thanks but when I do this and try to run it I get the error message "you tried to execute a query that does not include the specified expression "Count(*)/[Ahour]" as part of an aggregate function.

What does that mean? Thanks.

 

[SkipVought]

please post the entire SQL.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}