Is there a simple way to automatically add rows to a table or fields to a query.

[murry]

I am using Access 2007. I have an ODBC source feeding data into a table, to which I made a crosstab query that displays the useful data from that source. I need a way to add data(new field), using a form, that is a associated with the lines in the query. I've tried creating another table that uses the sample ID as the primary key, but I need it to automatically create a new row for each query line. Is there a way to do this, or better way to add data to a query. Examples are below. Thanks in advanced.

The ODBC data looks something like this

SampleID PeakName Conc
sample1 THF 50
sample1 MEOH 10
sample1 propanol 25
sample1 butanol 15
sample2 THF 21
sample2 MEOH 15
sample2 propanol 17
sample2 butanol 23

I have the querry look like:
SampleID THF MEOH propanol butanol (I need to be able to add a field here)
sample1 50 10 25 15
sample2 21 15 17 23

linked table I created:

SampleID LIMS #


sample1 1234567
sample2 4567891


the problem is, for this table I have to manually select each sample ID. I want it to automatically add the sample IDs as new ones are querried.

[June7]

You cannot add data to a crosstab query. Need to add records in the source.

[John_G]

I don't see what you are asking here - the samples are represented by rows in the crosstab query, not columns. Columns in the crosstab represent PeakNames. If you have Peaknames other than the 4 you have shown in the ODBC data, they will show up automatically in the crosstab.

"I want it to automatically add the sample IDs as new ones are querried."

What do you want to add the new sample ID's to? And what does it refer to?
I don't see what you need the separate "linked" table - are the sample numbers not in the ODBC data?

More details, please!

John

[murry]

I need to be able to add additional data that is not part of the ODBC transfer (i.e. "Lims#" from the sample above). I need to have it associcated with the rows I have querried, not the columns in the ODBC data. I was thinking that if a created another table that was linked to the query I could use a form to enter the addtional data. The problem is the new table (the it from above) requires you to add each SampleID row by row from a drop down menu. I am wondering if there is a way to have the rows automatically be created whenever a new row is created in the query. Thanks in advance.