Doing some of my own research, I found the following query which lets me automatically pull up data based on my [DocCreated] date field:
Year([DocCreated])=Year(Date()) And Month([DocCreated])<=Month(Date()) And Day([DocCreated])<=Day(Date())
What sort of modification should I make it I want the previous YTD data to show up based on today's date? In other words, the above query will give me data created thryu 7/27/2020, I'm looking for a query that will show me data for the previous year's same time frame, namely 1/1/2019 to 7/27/2019. Is that possible in Access?
Thank you.
Year([DocCreated])=Year(Date()) And Month([DocCreated])<=Month(Date()) And Day([DocCreated])<=Day(Date())
What sort of modification should I make it I want the previous YTD data to show up based on today's date? In other words, the above query will give me data created thryu 7/27/2020, I'm looking for a query that will show me data for the previous year's same time frame, namely 1/1/2019 to 7/27/2019. Is that possible in Access?
Thank you.