Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

updating MSAccess with field name called "Value"

Posted on 2005-04-12
1
Medium Priority
?
194 Views
Last Modified: 2010-04-17
How do you format an update statement when the fieldname I am trying to update is called "value" ?

example

table has 3 fields (name,value, age)

how to update rows  have a value > 10

update mytable
set value = "test"
where age > 10;



0
Comment
Question by:pnakaso
1 Comment
 
LVL 27

Accepted Solution

by:
Dabas earned 200 total points
ID: 13768611
Hi pnakaso,
Try:
Update  myTable
set [Value] = 'Test'
Where age > 10;

Dabas
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question