Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update the contents of one table with another.

Status
Not open for further replies.
GlenLynam

GlenLynam

MIS
Jul 26, 2002
121
Afternoon,

I have a question regarding queries that im hoping someon can shed some light on for me.

OK... I have 2 tables one contains the details from the logging that our phone switch kicks out the other has the contents of the local directory. So the first table literally has all the information about each call that goes through our switch. The second has 2 columns the first being the directory name the second the number that coincides with that.

What i actually want to do is cross reference the phone numbers from he directory with he ones the switch kicks out and then if there is a mtatch update the field on the switch information so that it has the directory name rather than a number. I have tried an update query with a if....hen statement in it but no joy. Am i in the right place or completely wrong.

Any helpsomeone can shed will be greatly appteciated as im really stuck with this now.

Glen
 
Sort by date Sort by votes
I just though that it would be easier to update the table when the reports are run, but please explain how i do it your way as its still a better idea than mine, which is currently...i dont have one!!!
 
Upvote 0 Downvote
Afternoon,

I have a question regarding queries that im hoping someon can shed some light on for me.

OK... I have 2 tables one contains the details from the logging that our phone switch kicks out the other has the contents of the local directory. So the first table literally has all the information about each call that goes through our switch. The second has 2 columns the first being the directory name the second the number that coincides with that.

What i actually want to do is cross reference the phone numbers from he directory with he ones the switch kicks out and then if there is a mtatch update the field on the switch information so that it has the directory name rather than a number. I have tried an update query with a if....hen statement in it but no joy. Am i in the right place or completely wrong.

Any helpsomeone can shed will be greatly appteciated as im really stuck with this now. I think i can join the queries in some way and do it that way. Can anyone please tell me how to complete this.

Glen
 
Upvote 0 Downvote
Hi

Make a query in the query design grid, place both tables in the query

Make a join on phone number

drag the columns you want into the lower part of the grid

voila it is done

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Select X of each variation of a field 1
Replies
8
Views
589
rashmibala
R
combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
514
Andrzejek
Andrzejek
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
4K
lameid
lameid
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
966
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top