If Statement Help

[vennies83]

Hey guys,



Not sure this is even possible. I have a database of over 2.3 million rows and want to run an if statement. I want to see if 2011 charges = 2010 charges by location. If they do, return "MATCH", if they don't, return "NO MATCH". I know it's simple, but I have had no luck getting anything.

Is it possible to do an IF statement of a value equaling another value exactly, instead of equaling some word or indicator?

One more simple question related to querying:

If I have a list of thousands of locations that are numbered, how do I search and return more than one location? It's easy to use Like for 1 location. Thinking choose can return more than location? How would that looked formatted?

Thanks for your time. I appreciate any feedback.

[alansidman]

Are the values for 2010 in a different field than 2011?

As to your second question, there are several ways to do this.

If you want to see all locations beginning with the number 1, then use Like 1*

If you want to see all locations beginning with the numbers 15, then use Like 15*

Finally, if you wish to include a series of locations then you could use the In function, ie. IN(1056, 2067, 5084, etc.)

You might find this helpful
http://www.techonthenet.com/access/queries/index.php
Alan