Filters

[Guest]

How do I filter each column of a table in a query if the data in each column
is EXACTLY the same.

 

[John W. Vinson]

How do I filter each column of a table in a query if the data in each column
is EXACTLY the same.

What is the difference between a duck?

EXACTLY the same as... what? Comparing one field to another field? Comparing
one record to another record? comparing a field in one record to a different
field in a different record? More details please!


John W. Vinson [MVP]

 

[Guest]

What is the difference between a duck?

EXACTLY the same as... what? Comparing one field to another field? Comparing
one record to another record? comparing a field in one record to a different
field in a different record? More details please!


John W. Vinson [MVP]
Let's say I have the following:

City
Conway $850 $850 etc
Little Rock $1000 $1000 etc
Rogers $600 $600 etc
Benton $980 $980
Dallas $1400 $1400
Houston $1800 $1800

How do I get say the low and average form month one, say the high and
average from month 2, the low from month 3, the high from month 4, etc.
Thanks!

 

[John W. Vinson]

City
Conway $850 $850 etc
Little Rock $1000 $1000 etc
Rogers $600 $600 etc
Benton $980 $980
Dallas $1400 $1400
Houston $1800 $1800

How do I get say the low and average form month one, say the high and
average from month 2, the low from month 3, the high from month 4, etc.
Thanks!

Since I cannot see your database, and nothing in your example refers to months
in any way, and since you still don't say the high and average OF WHAT, I
simply cannot help.

You are looking at your database. I'm not. You know how your data is
structured. I don't. You know what it is that you want to average, or sum, or
select. I don't.

Please post the question in a way that someone not looking over your shoulder
might have a chance to answer.

btw I grew up in Benton County (Bentonville, not Rogers) so I did get a
chuckle out of your example!

John W. Vinson [MVP]