I was wondering if it was possible to put an expression in the field box of a query?
Here is what im trying to do. I have a report that is based off six columns of a query. The first five columns are basic
information like product name, part number, department, manufacturer, and region. I would like give the user the ability to
change the variable that the 6th column contains. The query is based off a table with around 200 different fields. I would
like the user to be able to define which of these 200 variables fits in the last spot on the report.
I'm not sure if this is possible so i figured this would be a good place to look for tips.
Right now here is what I have.
Query: Main Query (Based off the table Basic Program Info)
Table: Basic Program Info
ComboBox: The rowsource of this combo box is Basic Program Info, and the row source type is Field List.
The query has 6 columns. The first five are Product, Part Number, Department, Manufacturer, and Region.
For the 6th column, I am trying to write and expression as the Field. Right now I have Form![Product Search].ComboBox, but
that doesn't seem to work.
Does anybody know how I could make this work or are there any other ideas I could try?