Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2010
    Posts
    5

    Unanswered: Adding a new column to a table- Automatically inputs into a current query

    Hello,

    I am having an issue with a query. Whenever I add a new column into a table (that has an existing query), I have to redo the query. Is there a way so that when I add a new column, all of the data is automatically inputted into the query?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    No
    its relativley rare to come accross a live requirement to add new columns, occasionaly when theres an underlying tbale change yes, but not in normal use.


    that would make me suspect that you may have a tabel design problem
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2010
    Posts
    5
    Well I would need to add new columns for new months. I have the columns set up as months. For instance, May-09. Next month I would add June-10. Any suggestions?

  4. #4
    Join Date
    May 2010
    Posts
    601
    Quote Originally Posted by mtkelly1989 View Post
    Well I would need to add new columns for new months. I have the columns set up as months. For instance, May-09. Next month I would add June-10. Any suggestions?
    I normally handle this by adding a new record for the new month, not a new column.

    I use a crosstab query to display the data.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

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