ITS STILL OTHER PROBLEME

[malkasoft10]

DEAR FRIEND
THANK YOU ALL ABOUT YOUR HELPE BUT AM SORRY THE PROBLEM NOT SOLVE.......WHY

BECAUSE WHEN I IGNORE THE ID WHICH IT HAVE PRIMERY KEY AND WHEN I TRY TO UPDATE ALL RECORD WILL UPDATE IN SAME RECORD>\
I.E IF I HAVE
12002 LAMA DANE
12003 BELL SMITH
WHEN I TRAY TO UPDATE LAMA TO LAMA1
THE RECORD WILL UPDATE TO
12002 LAMA DAN
12002 LAMA1 DANE

IF THERE ARE OTHER WAY TO UPDATE PLEASE HELPE ME >


FOR ALL MY appreciation:think:

[XLGibbs]

I am not sure the question is clear...

The Update statement should affect all records meeting the specified criteria. If you paste the SQL code it may be easier to fix the problem for you.

[XLGibbs]

I just noticed the other threads...if the original problem continues, please continue on the original thread...

Thanks..