Hi,
I am wondering if anyone can help me. I use access to track a team's attendance to training and display different reports about the training they attended. When I first set up the database I set up a Lookup Column where I "tick" who attended. With their name I put their team number i.e 01 Dan Reed. The team numbers have since changed (55 Dan Reed). If I change the lookup column data this just adds multiple choices (01 Dan Reed and 55 Dan Reed). I tried to set up conditional formatting so that if "01 Dan Reed" showed up on a report it would change it to and display the new number "55 Dan Reed". I though this would be the easiest way instead of going back and changing 6 years worth of look up column data however it didn't work. I am looking at changing the past data so that any "01 Dan Reed" will now show as "55 Dan Reed". Does anyone have any idea how I could achieve this? I am a total newbie to programming but I am looking for something like - IF "01 Dan Reed" = "55 Dan Reed". I know this may not be correct but should explain what I am looking to do. Any question please ask.
Cheers
Dan