Thanks ahead of time!
I am attempting to create an automated median database. They put in the parameters and out comes the median.
Basically, I have created a combo box in form [frm input] that will look at the fields of table [data]. I need to do this because the table fields change with each input of data. One time it will be sales next time quantity shipped.
Now, I have two issues.
The first is creating a make table query that takes the fields selected in [frm input] from table [data] and put in table [query data]. Each field has to remain constant each time the make table is ran. So, I added my own names. I attempted to run it, but it doesn't recognize anything.
Here is an example: Object: [frm Input]![Combo4]
Than I realize it isn't pulling data from the table [data] even if I have [data] pulled into the query in the show table section.
I don't know what to do.
The second issues is once I have that table created I need to insert a field in the beginning of the new table [query data] named "Rank" with data type 'Autonumber'. Remember, this must be automated, and I can't open the database each time to add this field. I can't find a way to automate an insert field in form after data is in it.
PLEASE HELP! I beg of you.

I am attempting to create an automated median database. They put in the parameters and out comes the median.
Basically, I have created a combo box in form [frm input] that will look at the fields of table [data]. I need to do this because the table fields change with each input of data. One time it will be sales next time quantity shipped.
Now, I have two issues.
The first is creating a make table query that takes the fields selected in [frm input] from table [data] and put in table [query data]. Each field has to remain constant each time the make table is ran. So, I added my own names. I attempted to run it, but it doesn't recognize anything.
Here is an example: Object: [frm Input]![Combo4]
Than I realize it isn't pulling data from the table [data] even if I have [data] pulled into the query in the show table section.
I don't know what to do.
The second issues is once I have that table created I need to insert a field in the beginning of the new table [query data] named "Rank" with data type 'Autonumber'. Remember, this must be automated, and I can't open the database each time to add this field. I can't find a way to automate an insert field in form after data is in it.
PLEASE HELP! I beg of you.
