J
JR
I gather and disseminate data for several different
customers whose requirements for the same data elements
varies with the model they are feeding.
One table is set up as follows:
Org ID | Location | POSTURE | PHASE | Rate
Posture and Phase are variables with 5 and 4 possible
variables respectively which give 20 possible combinations.
I must periodically rebuild the table data. I use an
append query to do that BUT the query design is such that
Posture and Phase are expressions (1 and 2 respectively).
Each time I update the table I am prompted to enter
parameters for the two expressions (Posture and Phase).
There has GOT to be a better way (such as using a form
that allows me to select the combinations of Posture and
Phase from a list).
Any help will be greatly appreciated.
customers whose requirements for the same data elements
varies with the model they are feeding.
One table is set up as follows:
Org ID | Location | POSTURE | PHASE | Rate
Posture and Phase are variables with 5 and 4 possible
variables respectively which give 20 possible combinations.
I must periodically rebuild the table data. I use an
append query to do that BUT the query design is such that
Posture and Phase are expressions (1 and 2 respectively).
Each time I update the table I am prompted to enter
parameters for the two expressions (Posture and Phase).
There has GOT to be a better way (such as using a form
that allows me to select the combinations of Posture and
Phase from a list).
Any help will be greatly appreciated.