Webpage to always show last 2 months

I have a webpage that pulls data from access. I want it to display 3 columns for Jan and 3 columns for feb. Once March 1st hits, I want  feb to replace Jan and march to appear on the webpage.....I have attached a word file that might might help picture it. I just don't know how to move the last month to the left of the page and add the new month on the right on the 1st day of the month...

Any help appreciated..
j8547Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
There is no document attached but to do what you are asking, you would use criteria.  However, we need a clearer definition of what exactly you want to see.  Are you saying that you want to see the "current month" which is January plus the next month?
0
j8547Author Commented:
so right now it would display dec and Jan. Feb 1st it would display Jan and Feb details and so on....
jobs.docx
0
PatHartmanCommented:
So you want it to display the current month and the previous month?  Getting a firm description of your requirements shouldn't be this difficult.  Will you be looking for future data so that the date range TODAY is Dec 1, 2017 - Jan 31, 2018 or is from the first day of the previous month to the current day of the current month?  that would make the date range Dec 1, 2017 - Jan 10, 2018 today and tomorrow it would be Dec 1, 2017 - Jan 11, 2018.

Option 1:
Where YourDateField Between DateSerial(Year(Date()), month(Date()) - 1, 1) And DateSerial(Year(Date()), month(Date()) + 1, 0)
Option 2:
Where YourDateField Between DateSerial(Year(Date()), month(Date()) - 1, 1) And Date()
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.