Prev: Break Occuring with no Break Point
Next: List Hangs when selecting all Items in list (See Code)
From: Julio Hidalgo on 2 Jul 2008 14:46
HEllo i am having troubles doing some kind of program, i want one to check
another table for begining to end. Something like this:

While (Barcelona.ABPOBL)
While (Pueblos_temp.Pueblos_temp_1)
WHERE (((BARCELONA.ABPOBL)=(Pueblos_temp.Pueblos_temp_1)))
SET (Barcelona.PERTENECE) = 8

Want to compare the first ABPOBL with the first Pueblos_temp_1 to the last
pueblos_temp_1, then the second ABPOBL with the first pueblos_temp_1

and so on
if they are equel i wanto to set Barcelona.PErtenece to 8

how can i traduce this to Access 2003

Thanks

From: Graham Mandeno on 2 Jul 2008 22:47
Hi Julio

You should be able to do this with a simple update query with an inner join:

Update Barcelona inner join Pueblos_temp
on Barcelona.ABPOBL=Pueblos_temp.Pueblos_temp_1
Set Barcelona.PERTENECE = 8

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

"Julio Hidalgo" <JulioHidalgo(a)discussions.microsoft.com> wrote in message
news:49926A97-CF66-465F-B0C8-D89797456620(a)microsoft.com...
> HEllo i am having troubles doing some kind of program, i want one to check
> another table for begining to end. Something like this:
>
> While (Barcelona.ABPOBL)
> While (Pueblos_temp.Pueblos_temp_1)
> WHERE (((BARCELONA.ABPOBL)=(Pueblos_temp.Pueblos_temp_1)))
> SET (Barcelona.PERTENECE) = 8
>
> Want to compare the first ABPOBL with the first Pueblos_temp_1 to the
> last
> pueblos_temp_1, then the second ABPOBL with the first pueblos_temp_1
>
> and so on
> if they are equel i wanto to set Barcelona.PErtenece to 8
>
> how can i traduce this to Access 2003
>
> Thanks
>


 | 
Pages: 1
Prev: Break Occuring with no Break Point
Next: List Hangs when selecting all Items in list (See Code)