T
tomsull
I have a create-table query calculating and summarizing data from an
input table and a couple of fixed tables. A report is based on that
created table. I want to bring into the report information from the
input table and a matching field from one of the lookup tables. Using
a list box and a query builder within that box I bring in one of the
fields of information I want. However, I can't seem to bring in more
than the one field even though I have them shown within the query
builder. Shouldn't I be able to bring in multiple fields? A second
list box accomplishes this but can I be guaranteed the order of the
two list boxes will match as the input table changes?
input table and a couple of fixed tables. A report is based on that
created table. I want to bring into the report information from the
input table and a matching field from one of the lookup tables. Using
a list box and a query builder within that box I bring in one of the
fields of information I want. However, I can't seem to bring in more
than the one field even though I have them shown within the query
builder. Shouldn't I be able to bring in multiple fields? A second
list box accomplishes this but can I be guaranteed the order of the
two list boxes will match as the input table changes?