Moving Fields/Data from one Table to another

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Todd D. Levy
    #1

    Moving Fields/Data from one Table to another

    I am moving 3 fields & associated data from 1 table to another.

    I will have to make the necessary changes to forms, code, queries, &
    reports, etc.

    It is the reports, and the queries that they are based on that most
    concern me.

    Can I simply edit the existing queries to reflect the new locations of
    the fields in question, but otherwise leave the queries as is?

    Can I similarly edit the existing reports?

    Or, will I have to recreate them from scratch?
    Tags: None
    • Mike Storr
      #2
      Re: Moving Fields/Data from one Table to another

      As long as field names stay the same, you can just edit the queries. If your
      reports are using those queries as their record source, then they should not
      be affected. If however the query name changes, or your recordsources are
      set to coded SQLs, you may need to edit those to reflect the new table.

      Mike Storr
      Veraccess Software
      https://www.veraccess.com



      "Todd D. Levy" <usenet001-tdlevy@spamex.c om> wrote in message
      news:MPG.1a8457 d7b0516b4198970 4@nyc.news.spea keasy.net...[color=blue]
      > I am moving 3 fields & associated data from 1 table to another.
      >
      > I will have to make the necessary changes to forms, code, queries, &
      > reports, etc.
      >
      > It is the reports, and the queries that they are based on that most
      > concern me.
      >
      > Can I simply edit the existing queries to reflect the new locations of
      > the fields in question, but otherwise leave the queries as is?
      >
      > Can I similarly edit the existing reports?
      >
      > Or, will I have to recreate them from scratch?[/color]


        Comment

        • Todd D. Levy
          #3
          Re: Moving Fields/Data from one Table to another

          Thanks Mike.

          In article <LOwSb.6554$qU3 .578931@news20. bellglobal.com> ,
          nobody@somewher e.con says...[color=blue]
          > As long as field names stay the same, you can just edit the queries. If your
          > reports are using those queries as their record source, then they should not
          > be affected. If however the query name changes, or your recordsources are
          > set to coded SQLs, you may need to edit those to reflect the new table.
          >
          > Mike Storr
          > www.veraccess.com[/color]

            Comment

            Previous template Next
            Working...