>or< expression criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two columns of data that I need to compare. One is this weeks data and one is last weeks data. I need to know if the values change from week to week. I only need to know if the value increases. I wanted to create a greater then expression however I am having issues with the criteria and the expression builder since it is not greater then a specific number.
Example
This week Next week
4 5
2 2
4 3
I only want to see the one that is now a 5.
Let me know if you need more info and I would appreciate any help!
joy
 
You might try using a criteria like this on the "Next week" field:
[This week]
Click to expand...

JoyKl said:
I have two columns of data that I need to compare. One is this weeks data
Click to expand...
and one is last weeks data. I need to know if the values change from week to
week. I only need to know if the value increases. I wanted to create a
greater then expression however I am having issues with the criteria and the
expression builder since it is not greater then a specific number.
 
It worked and was so simple. I guess I just couldn't see the forest from the trees anymore! thanks so much, you made my day!
 
Back
Top