I think I should mention that I have now created a very usable database which provides me with the correct answers to my dilemma and I was able to do this based primarily on the solution supplied by Fornation.
Although I am very much an amateur when it comes to Access, I was a professional programmer using the Cache language for over 10 years. One thing I learned during that time was that there can be a multitude of programming routes to take in order to arrive at a correct result. Maybe some of these would not be exactly pure in approach but definitely pure in result and, I think, that is what counts.
Thanks to everyone for their input, it has been really interesting to me.
Although I am very much an amateur when it comes to Access, I was a professional programmer using the Cache language for over 10 years. One thing I learned during that time was that there can be a multitude of programming routes to take in order to arrive at a correct result. Maybe some of these would not be exactly pure in approach but definitely pure in result and, I think, that is what counts.
Thanks to everyone for their input, it has been really interesting to me.
