Copying data

Hi there,

I recently created a query which gives me some information i needed to know from a large number of records. I now want to add this information into an existing table as an additional column, but with values only. I say this because the new information will not change and is always going to be relevant so i do not wish to have to run the query every time to view it.

Its hard to explain without showing someone but basically the best way i can explain is this - in MS Excel you can use a complicated formula to ascertain information, then once you are satisfied it is correct you can simply copy and paste the information using "values only" therefore being able to use the data but without the slow process of it working out formulaes. I wish to apply the same principle to MS Access information located in a query.

If anyone can understand what i mean and help i really would be most grateful.

Cheers

Chris

Hi Chris,

Basically you add a field to the table, and then convert your existing
query into an update query to update the new field with the calculated
values. If the existing query does not include the table where you want
to to put the calculated values, you will need to add it to the update
query, joined on the primary key (or another suitable key).

But standard practice in relational databases is to avoid storing
calculated values. If you'll get important time savings by doing so,
that's a reason to make an exception.

On Mon, 6 Mar 2006 16:46:22 +0000, bagnallc
wrote:



Hi there,

I recently created a query which gives me some information i needed to
know from a large number of records. I now want to add this information
into an existing table as an additional column, but with values only. I
say this because the new information will not change and is always
going to be relevant so i do not wish to have to run the query every
time to view it.

Its hard to explain without showing someone but basically the best way
i can explain is this - in MS Excel you can use a complicated formula
to ascertain information, then once you are satisfied it is correct you
can simply copy and paste the information using "values only" therefore
being able to use the data but without the slow process of it working
out formulaes. I wish to apply the same principle to MS Access
information located in a query.

If anyone can understand what i mean and help i really would be most
grateful.

Cheers

Chris

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.