Rather than editing my original question should perhaps ask or say.......I can easily do this with excel using an "if" statement, but not sure if, or how this can be done inside access. Seems to me this would/should be simple, however, I can't quite figure it out.
Again, thanks in advance