Recent content by jerbaldw

After some internet searching and manipulating I was able to come to the following solution using nested queries with a between operator. thanks you for the attempt. SELECT t1.lng_PERIOD, t1.chr_EE_RACF, t1.lng_INDIVIDUAL_TPROCESSING, ( SELECT...

So there is no way to utilize the lng_PERIOD values? I thought something like the string below would be possible..? lng_PERIOD >= lng_PERIOD-11

I'm having problems figuring this one out -- I'm fairly new to access. I have included a JPG attachment that shows the information I currently have in use and what I would like. I need a SQL statement that will generate the rolling 12 months by period. The end results will be a table that is...