cdxx139
Mechanical
- Sep 19, 2009
- 393
Hello,
I am a somewhat beginner Access use. I am writing an Access databse for room data for a hospital HVAC project (and template for future projects). I am comparing cfm from the load of the space, ventilation required by code, ACH requirements per AIA, and Dept of Public Health ACH requirements.
The max of one of these columns would be the cfm required to the space, but I cant figure it out in Access.
In Excel, I would use:
=MAX(R6,S6,T6,U6)
but that doesnt seem to work in Acess.
Any suggestions
I am a somewhat beginner Access use. I am writing an Access databse for room data for a hospital HVAC project (and template for future projects). I am comparing cfm from the load of the space, ventilation required by code, ACH requirements per AIA, and Dept of Public Health ACH requirements.
The max of one of these columns would be the cfm required to the space, but I cant figure it out in Access.
In Excel, I would use:
=MAX(R6,S6,T6,U6)
but that doesnt seem to work in Acess.
Any suggestions