Report

[LG]

Is it possible to run a query to find out how many letters were sent back for
the same reason if there are 3 fields that could possibly have the same
number.
Example: fields are Reason1, Reason2, Reason3 and possible entries are 1-89.
How would I query to find out for example how many were sent out with say a
#1 in any of those fields?

 

[Al Campagna]

LG,
Your question is a bit confusing.

3 fields that could possibly have the same number.

That would be an AND statement...
Field1 = 1 And Field2 = 1 And Field3 = 1

with say a #1 in *any* of those fields?

That would be an OR...
Field1 = 1 Or Field2 = 1 Or Field3 = 1
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."