Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-02-2005, 06:09 AM   #1
MadCat
Registered User
 
Join Date: Jun 2003
Location: Livingston, Scotland
Posts: 62
Thanks: 0
Thanked 0 Times in 0 Posts
MadCat
Question Update query not working

Hi all,

I'm sure this is easy to do but for some reason i just cannot get it working. Hopefully someone here can tell me where i'm going wrong.

I have two tables in a database and the have a linking unique field. I want to update a column in one table from a column in another where the linking ID field matches.

Here's what i have at present.

Code:
Update Table_1 inner join Table_2 On Table_1.ID = Table_2.ID
Set Table_1.[CHI Number] = [Table_2]![CHI_No]
This is just returning the CHI Number column as blanks instead of what i expected would be the same as Chi_No.

Can anyone shed some light on this for me?

Thanks in advance

MadCat is offline   Reply With Quote
Old 08-02-2005, 07:27 AM   #2
FoFa
Newly Registered User
 
FoFa's Avatar
 
Join Date: Jan 2003
Location: Texas, USA
Posts: 3,672
Thanks: 0
Thanked 4 Times in 4 Posts
FoFa is on a distinguished road
If you are running the query in design view to see it, it only returns what's in the columns TO BE UPDATED, not the values that WILL BE IN the column after the updates.
Misleading, sure, but the way it is.
FoFa is offline   Reply With Quote
Old 08-02-2005, 07:35 AM   #3
MadCat
Registered User
 
Join Date: Jun 2003
Location: Livingston, Scotland
Posts: 62
Thanks: 0
Thanked 0 Times in 0 Posts
MadCat
Smile

I see. That seems a wee bit daft but never mind. The query is indeed working. SHouldn't have ovelooked that fact.

Thanks for your help.

MadCat is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Update query adding to field values emartel Queries 2 04-15-2005 06:38 AM
Change an Insert query into an Update query violentjay25 General 7 02-25-2005 01:05 PM
update query from a table... Archo Queries 3 02-06-2005 07:27 PM
[SOLVED] Using an Event Procedure to run an Update Query from a Form kiermarie Forms 3 08-16-2002 05:26 PM
Update query not working sarahb845 Queries 10 07-25-2002 07:31 AM




All times are GMT -8. The time now is 03:44 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World