Totals in access report

[cbhealth]

I have a database that captures blood levels by date for each patient.
I need to do a summary report that will show the total number of blood
levels within a range. I need to show 5 different ranges.
ie. between 10 and 14(total)
between 15 and 19(total) etc.

What is the best way to do this?
Thanks

 

[Philip]

cb,
I'm not well educated with access, but I'm fairly certain what you need is a
query.
Click on queries, and then create one in design view. Then select the blood
level field for the "Field:" field. Under criteria, you should be able to
type something to the effect of bloodlevel<10 and bloodlevel>14. Do the same
for each criteria going across the fields except replace the criteria with
what you want. Access will fix the typing to include quotation marks where
needed.

Save it, then you can view by double clicking it (I think). I'm new to
access...but I believe this will work. Good luck.

 

[JohnR]

Make a query based on your data. Make one field for each Blood Level as in
the sample below. Then do a group by on the query and SUM ach level. The
code says to check if the blood level is within the specified range. If it
is give it a value of 1 and if not 0. When you SUM the column you will get
a total count of entries that fall withinthat range.

10to14:IIf([bloodlevel]>=10 and [BloodLevel]<=14,1,0)
15to19:IIf([bloodlevel]>=15 and [BloodLevel]<=19,1,0)

 

[Duane Hookom]

I would build a flexible system that makes use of a "range" table like:
tblBloodLevelRanges
================
BLFrom BLTo BLTitle
10 14 10-14
15 19 15-19
--etc-----
You can add this to a query with your blood levels and set the criteria
under a field to:
Between BLFrom And BLTo

This will allow you to group by BLFrom, BLTo, BLTitle, and count other
field(s).