Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2010
    Posts
    87

    Unanswered: Query Not Apply Changes to Table

    Hello all,

    I created to concatenate queries today that I thought were all set. However, they don't update the table. They only give me a new table with the data combined. I want them to update the table. So I look at Update Query and the fields are different and I think I did the wrong thing.

    I'll use the easy example: I combined a prefix and a item number. Works when I run the query, just doesn't update the table.

    Here's what Ive got

    Field: ITEM_PFX | ITEM_NUM | sku: [ITEM_PFX] & [ITEM_NUM]
    Table: TABLE NAME | TABLE NAME

    Sort (all blank)
    Show (all three fields checked)
    Criteria (all blank)
    or (all blank)

    Now in the UPDATE QUERY screen the options are:
    Field:
    Table:
    Update To:
    Criteria:
    or:

    How to I port my Query data into the UPDATE query! OR do I have to make another type of query!

    While I'm loving results and have been at this for a week, I keep running into walls! UGH Your help is appreciated!

    RB

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    don't fold data back into a single column, leave the separate columns as they are in storage. you can alwasy merge data as an when required in a query. one thing to bear in mind is that there are different elements.
    theres the data storage element (ie how you store, manipulate or process the data)
    theres the presentation element (ie how you represent the data on forms or reports).
    don't be tempted to store data in a style or format used in a form or report. leave the presentation to the presentation layer.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Aug 2010
    Posts
    87
    Thanks again!

    I moved "[ITEM_PFX] & [ITEM_NUM]" to the update to field and took it out of the FIELD name. And viola! Man this stuff is complicated but easy at the same time. I'm learning on the fly!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •