|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#16
May 30th, 2008, 01:06 PM
|
|||
|
|||
|
Fantastic....that works great for the select...
But how do I get that into an Update Query and actually apply those values to existing fields? Thats where I am stuck... Thank you very much for your help...VERY apprecaited...
|
|
#17
May 30th, 2008, 02:01 PM
|
||||
|
||||
|
Ok, using the same sample db I attached previously, I create an update query based on the query where I parsed the data.
Code:
UPDATE Query1 SET Query1.f1 = [part1], Query1.f2 = [part2], Query1.f3 = [part3], Query1.f4 = [part4];
__________________
Did I help you? If so gimme rep by clicking on the scales at the top right corner of this post  Madness does not always howl. Sometimes, it is the quiet voice at the end of the day saying, "Hey, is there room in your head for one more?"
|
|
#19
May 30th, 2008, 02:17 PM
|
|||
|
|||
|
Fantastic...that was it...
Just dont understand why it was nessessary to create another query to do the update? YOu were not kidding...that was crazy to do that update... VERY APPRECIATED...thank you once again... Have a great weekend
|
|
#20
May 30th, 2008, 02:20 PM
|
||||
|
||||
|
The reason for the 2 separate queries....
1. You can pull up select records in the first 1, update with the 2nd 2. The expressions had to be defined, this is the easiest way to do it. Last edited by sbenj69 : May 30th, 2008 at 02:23 PM.
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
