By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,609 Members | 1,119 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,609 IT Pros & Developers. It's quick & easy.

I have a problem in query

P: 2
i can't run this query in ms access 2003

please help me

query;
book = table
field6,field1 = fields in book table

Expand|Select|Wrap|Line Numbers
  1. update book set field6=LEFT(field1, 2)
  2.  
May 24 '07 #1
Share this Question
Share on Google+
4 Replies

JConsulting
Expert 100+
P: 603
i can't run this query in ms access 2003

please help me

query;
book = table
field6,field1 = fields in book table

Expand|Select|Wrap|Line Numbers
  1. update book set field6=LEFT(field1, 2)
  2.  

what are the data types? Are you getting any errors?
May 24 '07 #2

missinglinq
Expert 2.5K+
P: 3,532
When something goes awry, and there's an old fashioned VB(A) function like Left involved, it's always a good idea to check your references!
May 24 '07 #3

P: 2
thank u all

i am solve my problem;

4u
May 25 '07 #4

NeoPa
Expert Mod 15k+
P: 31,770
Perhaps you could explain what was wrong.
I'm sure I'm not alone in thinking there was nothing wrong with the SQL you posted.
May 25 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.