how to delete information from original document and rename

Discussion in 'Microsoft Access External Data' started by Guest, Jul 25, 2007.

  1. Guest

    Guest Guest

    I already have a program I use in access. I use the same program each year at
    school. How can I use same set-up document without creating the document. I
    need to remove information from document and rename to current year.
     
    Guest, Jul 25, 2007
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    You don't. Instead you put something like a data/time or SchoolYear field in
    appropriate tables and set up your queries based on those fields. That way
    you can have multiple years' worth of data in one database. That sure comes
    in handy if you ever need to compare and contrast current year data against
    previous years.
    --
    Jerry Whittle, Microsoft Access MVP
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

    "rachel01" wrote:

    > I already have a program I use in access. I use the same program each year at
    > school. How can I use same set-up document without creating the document. I
    > need to remove information from document and rename to current year.
     
    Guest, Jul 26, 2007
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Merge information from excel to a word document

    Guest, Sep 23, 2004, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    164
    John Nurick
    Sep 23, 2004
  2. Guest

    Rename fieldName and keep Excel sheet when exporting data

    Guest, Jan 17, 2006, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    289
    John Nurick
    Jan 18, 2006
  3. Guest

    Import and Rename Unique Files

    Guest, Mar 8, 2006, in forum: Microsoft Access External Data
    Replies:
    5
    Views:
    185
    Guest
    Mar 9, 2006
  4. Guest

    Automate table export and rename

    Guest, May 16, 2007, in forum: Microsoft Access External Data
    Replies:
    3
    Views:
    323
    Guest
    May 16, 2007
  5. Guest

    Mass rename and import

    Guest, May 20, 2007, in forum: Microsoft Access External Data
    Replies:
    9
    Views:
    229
    Guest
    May 22, 2007
Loading...

Share This Page