Year Return Issue

  • Thread starter Thread starter David Whitaker
  • Start date Start date
D

David Whitaker

Yesterday I posted a question about how to return records that had data
only.
What was done was that Not 0 Or Not Is Null was put in different rows of the
criteria in the query. That worked very well, but it created another issue.
I am asking for a year in an expression set as the criteria to populate the
query by. It doesnt matter what year is put into the expression and it
returns all records now.
How do you get the query to honnor the year expression and hide 0's or null
rows?
This worked before I added the Not 0 Or Not Is Null to each row. I did move
the year expression field in front of the others and I tried to set Not 0 Or
Not Is Null 1 row ahead of the expression and it still doesnt produce the
results needed.
 
I did it again.
Funny how you can walk away from a station and come back and answer your own
questions.

The criteria needs to be put in every row that was added.
 
Hi David.
Place the Year filter in each row where you also have de Not 0 Or Not is Null.
Hope this helps.
Fons
 
You need to put the following into a blank field of your query:
DataYear:Year([NameOfYourDateField])
Then in each of the six rows where you have the Not 0 Or Not Is Null
criteria, you need to put the year you want to limit the data to in the
criteria of the DataYear field. Ex: 2004.
 
Back
Top