J
Jani
Need some help on how to do this, please. The fields needed are Region,
Location, Date1 (YYYYMM), Prepared by, and then each month the location would
fill in information on metrics, some of which are standard (water, waste,
etc, and then seldom used ones which would be picked from a list). For each
metric the information needed is actual usage and dollars for that particular
month. These fields would then be Metrics, Actual usage and US Dollars. I've
ste up a temp table to capture the data from a form and then using an append
query to move the data to a table but this is quite cumbersome and I'm
thinking there must be a better way. Can someone please get me going in the
right direction or have a site that has a good example of a db that would
work for this? As always, thanks in advance for your continued help!
Location, Date1 (YYYYMM), Prepared by, and then each month the location would
fill in information on metrics, some of which are standard (water, waste,
etc, and then seldom used ones which would be picked from a list). For each
metric the information needed is actual usage and dollars for that particular
month. These fields would then be Metrics, Actual usage and US Dollars. I've
ste up a temp table to capture the data from a form and then using an append
query to move the data to a table but this is quite cumbersome and I'm
thinking there must be a better way. Can someone please get me going in the
right direction or have a site that has a good example of a db that would
work for this? As always, thanks in advance for your continued help!