Show current year data only.

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

Floyd Forbes

I have a query with this year data and last year data. Without deleting last
year data. How can I only show this year data by writing an expression?
I need an expression that will change on it's own 12/31/05 to 1/1/2006.

Floyd
 
In the Criteria row of your query:

Between DateSerial(Year(Date()), 1, 1) And DateSerial(Year(Date()), 12, 31)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need to show current year and prior year totals 6
How to chart months by financial year 0
How to query data on monthly basis 3
Excel Message box called if 1 of 3 options is entered. 4
Parameters to search between years 2
Calculating last year 4
Excel Msgbox runing beyond posted cell range. 1
select fiscal year on a query 1

Back
Top