Average in a report question

[Karl]

I'm an absolute beginner on Access.

I've constructed a database for patients on a clinical trial.

All Patients are "Screened†some are then "Randomized"

I've done a report that shows the patients' average age by sex (average age
female, average age male). This works fine for all patients but I also need
to show the average age of the patients randomized in this same report
(again, not all patients are randomized.

How do I do this?

 

[Duane Hookom]

What do you mean by "randomized"? Is this a value stored in a field that you
need to tell us about?

How about some sample records and desired display in the report?

 

[John W. Vinson]

I'm an absolute beginner on Access.

I've constructed a database for patients on a clinical trial.

All Patients are "Screened” some are then "Randomized"

I've done a report that shows the patients' average age by sex (average age
female, average age male). This works fine for all patients but I also need
to show the average age of the patients randomized in this same report
(again, not all patients are randomized.

How do I do this?

Create a Query based on the table. Select the Age field and the field that
indicates whether the patient has been randomized.

Change the query to a Totals query by clicking the Greek Sigma icon (looks
like a sideways M).

Leave the default Group By on the Randomized field, and change it to Avg on
the age field. You can also Group By the sex field if you want.

Base a report on this query.

If that's not addressing the problem please post back with more details about
your table and the problem.