You've been waiting for an answer to this for a while haven't you?
You're not likely to get one because it sounds as though you are operating within a database within Access and it's how that database has been structured that will influence how you perform these routines.