G
Golfinray
How do I filter each column of a table in a query if the data in each column
is EXACTLY the same.
is EXACTLY the same.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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]
G
Golfinray
CityJohn W. Vinson said: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:
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!
J
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]