Click here to Skip to main content
13,191,400 members (72,406 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I have two Table Name Table1 and Table2 as below:-
Mobile Remarks

Mobile Name Fname Address

Now I want that data should copy into the data and rest of the columns of Table2 data should be copy in the table1.remarks column.
Please send me query

As you send the query am using in MS-Access 2007 but its giving error message that Syntax error in query expression "select mobile".
Posted 20-Jan-13 22:45pm
Updated 21-Jan-13 23:54pm
OriginalGriff 21-Jan-13 4:46am
Never post your email address in any forum, unless you really like spam! If anyone replies to you, you will receive an email to let you know
Richard MacCutchan 21-Jan-13 4:46am
This is a repost; see below in QΑ list.
OriginalGriff 21-Jan-13 4:48am
I was just telling him that when you were telling me! :laugh:
OriginalGriff 21-Jan-13 5:00am
Richard, did you edit that?
I got strange characters in the email, that I don't normally:
"This is a repost; see below in QΑ λιστ."
If you didn't, then I'll mention it to Chris in Sugs'n'Bugs.
Richard MacCutchan 21-Jan-13 5:02am
Sorry I hit my "switch language" keys by mistake so it came out as Γρεεκ characters.
OriginalGriff 21-Jan-13 5:05am
I am not going to ask why you have Cyrillic as one of your options! :laugh:
Richard MacCutchan 21-Jan-13 5:12am
I don't, but I do have Greek. I started learning it a few years ago but didn't keep up with the lessons. It remains on my todo list.
OriginalGriff 21-Jan-13 4:47am
And don't repost!
If you have extra data to add to your question, use the "Improve question" widget to edit your question and provide better information.
Posting the same question twice is rude, and can slow a response dramatically.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Try out with below mentioned query.


Hope this will help you..
Rajesh Kinger 22-Jan-13 5:22am
It's still not working its giving error message that "Sytax error in query expression 'select mobile'.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.171017.1 | Last Updated 22 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100