Page 1 of 2 12 LastLast
Results 1 to 15 of 24
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.

  8. #8
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would like to make some names of tables more generic. Right now they are specific to a certain month. I would like to name them Baseline and Current. I would like the queries that use these tables to be changed also. Is there a way to do this. Same for queries - can you change a name of a query and have the subsequent queries that use that query, reflect the change.

  9. #9
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind - as well as copying & renaming the Tables.

    If you open up the relevant Query in DesignView, you should be able to see - depending on the circumstances - the relevant Table or Query that would need renaming.

    HTH
    Gre

  10. #10
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind - as well as copying & renaming the Tables.

    If you open up the relevant Query in DesignView, you should be able to see - depending on the circumstances - the relevant Table or Query that would need renaming.

    HTH
    Gre

  11. #11
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind - as well as copying & renaming the Tables.

    If you open up the relevant Query in DesignView, you should be able to see - depending on the circumstances - the relevant Table or Query that would need renaming.

    HTH
    Gre

  12. #12
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind - as well as copying & renaming the Tables.

    If you open up the relevant Query in DesignView, you should be able to see - depending on the circumstances - the relevant Table or Query that would need renaming.

    HTH
    Gre

  13. #13
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind - as well as copying & renaming the Tables.

    If you open up the relevant Query in DesignView, you should be able to see - depending on the circumstances - the relevant Table or Query that would need renaming.

    HTH
    Gre

  14. #14
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind - as well as copying & renaming the Tables.

    If you open up the relevant Query in DesignView, you should be able to see - depending on the circumstances - the relevant Table or Query that would need renaming.

    HTH
    Gre

  15. #15
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The way I would attempt to carry out what you are suggesting is to take a backup copy of the Database. In the backup, then edit the SQL in the various Queries that you have in mind - as well as copying & renaming the Tables.

    If you open up the relevant Query in DesignView, you should be able to see - depending on the circumstances - the relevant Table or Query that would need renaming.

    HTH
    Gre

Page 1 of 2 12 LastLast

Posting Permissions

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