Re: Find and Replace

From: steve walker (sagwalker_at_blueyonder.co.uk)
Date: 08/11/04

  • Next message: JoeElla: "Re: sending a report using SendObject" 
    Date: Wed, 11 Aug 2004 18:59:59 GMT

    I'm in a school and need to provide data on students.

    tblPUPIL (PupilID, Surname, FirstName, Form, Class, Year_Group)

    Data in this table is (0001, Smith, Greg, 07A, 07A/In1, 7)

    For example a pupil would start school in Year 7 therefore 07A is the Form, 07A/In1 is the Class, 7 is the Year Group. As they move into the next Year the data needs to be changed to 08A as the Form, 08A/In1 as the Class and 08 as the year group.

    Pupils move up a year until they leave school. At the end of the final year (Year 11) I archive the records from tblPUPIL. This allows me to use the find and replace function in Acess to move Year 10 to Year 11 without losing and data relationships.

    I can use an append/delete query to archive the table but want to find a method of using a macro to carry out the function of Find and Replace e.g. Find all Year 7 and replace with Year 8.

    Cheers

    Steve 

    -- 
---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"
Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com
"Jeff Boyce" <JeffBoyce_IF@msn.com-DISCARD_HYPHEN_TO_END> wrote in message news:uawNjY5fEHA.3928@TK2MSFTNGP11.phx.gbl...
> Steve
> 
> I'm not there, nor thee, so I don't know about your subject area.
> 
> I do know that you have alternatives to physically moving records (append to
> another table, delete from first).
> 
> I don't have any idea what information about the students you feel it is
> necessary to move around, rather than referring to.
> 
> Can you provide a table design description (tables, fields,
> description/example of what's in those fields)?
> 
> -- 
> More info, please ...
> 
> Jeff Boyce
> <Access MVP>
>
  • Next message: JoeElla: "Re: sending a report using SendObject"