A
AccessNeophyte
Greetings,
I have an Excel spreadsheet that I use to capture:
Column A) Day of the month (1-May, 2-May, etc.)
Column B) How many clients were in residence on each day (Occupancy)
Column C) Total Capacity (27)
Column D) Shows a "1" if the Occupancy is 90% or more of the Total
Capacity, else "0"
The Totals row shows:
Column B) The average Occupancy for the month
Column D) Totals the times there is a "1" in Column D
Is there a way for me to capture this data in a Report?
I've got a query set up that uses these expressions:
For AdmitDate: <=[Date Requested]
For DischargeDate: Is Null Or >[Date Requested]
This shows me the clients in residence on the Date Requested, but I
have to run it for each day of the month, and get the total from the
bottom of the datasheet.
What are my chances? Please let me know if I've not supplied enough
information.
Thanks,
Liz
I have an Excel spreadsheet that I use to capture:
Column A) Day of the month (1-May, 2-May, etc.)
Column B) How many clients were in residence on each day (Occupancy)
Column C) Total Capacity (27)
Column D) Shows a "1" if the Occupancy is 90% or more of the Total
Capacity, else "0"
The Totals row shows:
Column B) The average Occupancy for the month
Column D) Totals the times there is a "1" in Column D
Is there a way for me to capture this data in a Report?
I've got a query set up that uses these expressions:
For AdmitDate: <=[Date Requested]
For DischargeDate: Is Null Or >[Date Requested]
This shows me the clients in residence on the Date Requested, but I
have to run it for each day of the month, and get the total from the
bottom of the datasheet.
What are my chances? Please let me know if I've not supplied enough
information.
Thanks,
Liz