Results 1 to 8 of 8
  1. #1
    xsbucks is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011
    Posts
    9

    Complete Newbie Question

    I am just starting to experiment with access, I want to create a row that has just one value for the complete row. Is there an easy way of doing it without having to copy and paste for 1200 columns?



    Thanks for your help, Apologies as i am sure this has been asked before and i couldn't find it.

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481
    I doubt that you should be thinking about 1200 columns. Access is more row-oriented, with each row being a record that should hold a unique set of facts (columns). For example, a personnel record might contain columns for first, middle, and last names, address, social security number, telephone number and birth date. In this example, each of the columns has a close, if not unique, tie to the individual.

  3. #3
    xsbucks is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011
    Posts
    9
    I think i might have got my columns and rows mixed up in this example. I will try and elaborate, I have 1200 users all with their own personal records. What i need is to populate an entire column with the same "Province" for example.

    First Name Last Name City Province

    The value of province must remain the same throughout all 1200 users.

    Hope that clarifies what i am after. Thanks

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    It sounds to me as though you need to create and run an Update Query.
    Have a look at the help file and post back if you need more help.
    Make a back up of your data first.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    xsbucks is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011
    Posts
    9
    Thanks Bob, I looked at the help file and came to the conclusion that is what i need to do. However it is very vague in the help file to what i need it to do.

  6. #6
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    MAKE A BACKUP

    Open a new query.
    Select SQL View
    Copy and paste:

    UPDATE TableName SET TableName.ColumnName = "DataToInsert";

    Select Design View
    Select Query on the Menu Bar and then select Run

    Take a look at your table to check that data has been changed
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  7. #7
    xsbucks is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011
    Posts
    9
    Worked like a charm! Thanks Bob!

  8. #8
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    You're welcome. Glad we were able to help
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. newbie question
    By hannuk in forum Access
    Replies: 1
    Last Post: 12-12-2011, 07:18 AM
  2. Hi and a newbie question :)
    By wheelspin in forum Queries
    Replies: 3
    Last Post: 11-28-2011, 01:11 PM
  3. Newbie question
    By Patience in forum Queries
    Replies: 4
    Last Post: 11-24-2010, 02:18 AM
  4. Very Newbie Question
    By paralogical in forum Access
    Replies: 4
    Last Post: 10-11-2010, 06:55 PM
  5. Newbie question
    By The_Dude in forum Programming
    Replies: 2
    Last Post: 12-23-2007, 07:11 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