Results 1 to 3 of 3
  1. #1
    lavoij is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Aug 2022
    Posts
    1

    modifying all data in a field table


    I would like to know if it is possible to modify all the data that has been entered in a field in a table. For instance, is it possible to multiply by 10 all the entries in one field so that data can now be entered using a different unit (cm vs mm).

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Of course you can, you would need to use an update query:

    Code:
    Update tblYourTable Set [yourCMField]=[yourCMField]*10
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    As Gicu said, use and Update query. If you are not familiar with code, you can do this in the query window, Go to Create/Query Design, Select the table, Choose Update Query at the top, Select the field and then in the Update To row/box, do the calculation you need like in Gicu example above [filedname]*10, etc.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Daily imported data to table for modifying.
    By Ken_Spc in forum Access
    Replies: 1
    Last Post: 06-20-2017, 04:22 PM
  2. Modifying the Table Field into Records
    By mkrylataya in forum Access
    Replies: 2
    Last Post: 11-04-2016, 11:45 PM
  3. Replies: 2
    Last Post: 03-18-2016, 05:47 AM
  4. modifying data from ODBC
    By Noewon in forum Queries
    Replies: 4
    Last Post: 03-03-2011, 08:23 PM
  5. Update Query: Modifying Data Using Top Values
    By William McKinley in forum Queries
    Replies: 1
    Last Post: 11-30-2010, 02:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums