Raskew - Another more urgent project came up that I had to attend to before getting to your solution. I tried it out today and it works great. Thanks so much for the help!!
Okay I'll give it a try. I'm pretty new at this, so it may take me a bit to figure everything out. I'll let you know how it turns out...
Thanks for all your help!
I have a query with the following fields:
[Clinic] [Month] [Year] [NewPatients]
Some of the calculations I would like to do are based on the number of new patients that a certain clinic received in the previous month. Does anyone have any suggestions on how I can create a field that has the...