R
Rob
I asked this question earlier and because I haven't got an
answer yet, I thought I'd rephrase the question.
I have a main table (tblEntry) on a form for monthly
records and I have 2 other tables (tblInvoices and
tblProduction)as subforms on that form. The tblInvoices
table has records that I want to summarize based on
criteria in another field(i.e., I want to summarize a
utility consumption field(called consumption - number data
type) by the type of utility it is (gas, electric, or
water - text data type). In addition I want to summarize
the tblProduction table which has number of parts ran in
production per machine in the plant for that month.
I want to put this summary of information into a listbox,
but I can't get the right combination of queries set up to
do it. I can get the tblInvoices info in there by using a
crosstab query and I can get the tblProduction info into
as well by using a select query. Can I concatenate both
queries somehow in the listbox Rowsource property?
answer yet, I thought I'd rephrase the question.
I have a main table (tblEntry) on a form for monthly
records and I have 2 other tables (tblInvoices and
tblProduction)as subforms on that form. The tblInvoices
table has records that I want to summarize based on
criteria in another field(i.e., I want to summarize a
utility consumption field(called consumption - number data
type) by the type of utility it is (gas, electric, or
water - text data type). In addition I want to summarize
the tblProduction table which has number of parts ran in
production per machine in the plant for that month.
I want to put this summary of information into a listbox,
but I can't get the right combination of queries set up to
do it. I can get the tblInvoices info in there by using a
crosstab query and I can get the tblProduction info into
as well by using a select query. Can I concatenate both
queries somehow in the listbox Rowsource property?