>or< expression criteria

J

JoyKl

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
 
B

Brian Camire

You might try using a criteria like this on the "Next week" field:
[This week]

JoyKl said:
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.
 
J

JoyKl

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!
 

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

Top