updating MSAccess with field name called "Value"

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


table has 3 fields (name,value, age)

how to update rows  have a value > 10

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

Question by:pnakaso
    1 Comment
    LVL 27

    Accepted Solution

    Hi pnakaso,
    Update  myTable
    set [Value] = 'Test'
    Where age > 10;


    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    TextBlock Stops Updating 2 48
    sumHeights  challenge 17 50
    VBA color chart bars 12 51
    changeXy challenge 13 40
    INTRODUCTION We all know how to code. But at times you simply want to insert a common code block into your existing code and amend it as per your requirements. This tool not only saves you time but also saves you the pain of typing it all out aga…
    Purpose To explain how to place a textual stamp on a PDF document.  This is commonly referred to as an annotation, or possibly a watermark, but a watermark is generally different in that it is somewhat translucent.  Watermark’s may be text or graph…
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
    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 …

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now