M
Michael DiCostanzo
I have a project where I need to manage a facility operating permit.
The permit has a lot of devices in it, each that can have multiple
conditions.
Right now, everything is contained in Word tables. That makes it very
difficult to manage changes or to organize the information in a
different way. Access would be really good for organizing and
managing the data.
A summary of the table design is shown below:
Conditions (ConditionID, ConditionDescription) [pk: ConditionID]
Device (DeviceID, DeviceDescription) [pk: DeviceID]
DeviceConditions (dcID, DeviceID, ConditionID) [pk: dcID]
Monitoring (monID, ConditionID, monFrequency, monDescription) [pk:
monID]
Process (ProcessID, ProcessDescription) [pk: ProcessID]
ProcessSysDevice (psdID, ProcessID, sysNum, DeviceID) [pk: psdID]
System (sysNum, SystemID, SystemDescription) [pk: sysNum]
What I would like to do is create a report or query that gives me the
following results:
Monitoring Condition Frequency
Devices Device Descriptions
For example, the output might look something like this:
Monitoring Condition = CO Source Test Frequency = Annually
Devices = D10 Description = Boiler #1
Devices = D11 Description = Boiler #2
Devices = D12 Description = Boiler #3
Ideally, I'd like the Monitoring Condition to be scrollable. Some of
the Frequencies can also be scrollable. In this example, the CO
Source tests could be annually, or they can be every 3 years. I'd
like to select both, if applicable, and have the results shown below
as indicated, or something like it. There are other similar items I
need to set up in a similar manner, but they al would follow this
guide.
If anyone can point me in the right direction for solving this
problem, I'd greatly appreciate it. Thanks in advance.
The permit has a lot of devices in it, each that can have multiple
conditions.
Right now, everything is contained in Word tables. That makes it very
difficult to manage changes or to organize the information in a
different way. Access would be really good for organizing and
managing the data.
A summary of the table design is shown below:
Conditions (ConditionID, ConditionDescription) [pk: ConditionID]
Device (DeviceID, DeviceDescription) [pk: DeviceID]
DeviceConditions (dcID, DeviceID, ConditionID) [pk: dcID]
Monitoring (monID, ConditionID, monFrequency, monDescription) [pk:
monID]
Process (ProcessID, ProcessDescription) [pk: ProcessID]
ProcessSysDevice (psdID, ProcessID, sysNum, DeviceID) [pk: psdID]
System (sysNum, SystemID, SystemDescription) [pk: sysNum]
What I would like to do is create a report or query that gives me the
following results:
Monitoring Condition Frequency
Devices Device Descriptions
For example, the output might look something like this:
Monitoring Condition = CO Source Test Frequency = Annually
Devices = D10 Description = Boiler #1
Devices = D11 Description = Boiler #2
Devices = D12 Description = Boiler #3
Ideally, I'd like the Monitoring Condition to be scrollable. Some of
the Frequencies can also be scrollable. In this example, the CO
Source tests could be annually, or they can be every 3 years. I'd
like to select both, if applicable, and have the results shown below
as indicated, or something like it. There are other similar items I
need to set up in a similar manner, but they al would follow this
guide.
If anyone can point me in the right direction for solving this
problem, I'd greatly appreciate it. Thanks in advance.