Report

  • Thread starter Thread starter LG
  • Start date Start date
L

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?
 
LG,
Your question is a bit confusing.
3 fields that could possibly have the same number.
Click to expand...
That would be an AND statement...
Field1 = 1 And Field2 = 1 And Field3 = 1
with say a #1 in *any* of those fields?
Click to expand...
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."
 
Back
Top