If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Copying data
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
multiple docs, one data source | kp | Mailmerge | 12 | January 31st, 2005 04:41 PM |
Pulling data from 1 sheet to another | Dave1155 | Worksheet Functions | 1 | January 12th, 2005 05:55 PM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |