Avatar of j8547
j8547
 asked on

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..
ASPMicrosoft AccessPHPMicrosoft Word

Avatar of undefined
Last Comment
PatHartman

8/22/2022 - Mon
PatHartman

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?
j8547

ASKER
so right now it would display dec and Jan. Feb 1st it would display Jan and Feb details and so on....
jobs.docx
ASKER CERTIFIED SOLUTION
PatHartman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes