Average Formula

[mscomputerskills]

Version: 11
Experience Level: NONE (new user)


I need the total number of patients who received 2 or more GLYCO-POC test 91 days apart within the last year. My tables are: Lab_Result (holds the value), D_lAB_RECVD(holds the date received).

I will also need the average of these lab results.

Is there a simple way to find the average of a field that have numerical value. For instance if I have 600 patients that have a lab result values range from 3.1 to 15.7. How do you get the average test result.

 

[Madawc]

I answered your other post. Please don't post twice.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10