R
Rob
I have a utilities database that I'm having trouble
getting all of the sums into a listbox. I know how to
set the RowSource for the list box, but I can't get the
combined info that I'm looking for. The db has a form
(bound to a table called tblEntry that contains the
recordID, month, & plant# ) with a couple of subforms. I
enter all of the monthly consumption for each utility
(gas, water, electric - I use a field called UtilityType
to determine which it is) into one subform(data is in a
table called tblInvoices) and I enter how many pieces
were produced on each machine that month into another
subform (data is in a table called tblProduction).
I want to show on this listbox the history per month per
plant the total consumption for each utility and the sum
of produced pieces.
I tried using a crosstab query for the listbox and it
worked well for the utilities, but I couldn't figure out
how to include the production total into it. Can anyone
help me out.
Rob
getting all of the sums into a listbox. I know how to
set the RowSource for the list box, but I can't get the
combined info that I'm looking for. The db has a form
(bound to a table called tblEntry that contains the
recordID, month, & plant# ) with a couple of subforms. I
enter all of the monthly consumption for each utility
(gas, water, electric - I use a field called UtilityType
to determine which it is) into one subform(data is in a
table called tblInvoices) and I enter how many pieces
were produced on each machine that month into another
subform (data is in a table called tblProduction).
I want to show on this listbox the history per month per
plant the total consumption for each utility and the sum
of produced pieces.
I tried using a crosstab query for the listbox and it
worked well for the utilities, but I couldn't figure out
how to include the production total into it. Can anyone
help me out.
Rob