By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,704 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,704 IT Pros & Developers. It's quick & easy.

Help with filtering results

P: n/a
I have a form which shows results from a query i have 2 fields one max
and one min there is always 2 records of the same record i want to
have min showing on one record and max showing on the other without
showing the min if max and max if min what is the easiest way to do
this? thanks

Aug 13 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
sh*********@uk.gm.com wrote:
I have a form which shows results from a query i have 2 fields one max
and one min there is always 2 records of the same record i want to
have min showing on one record and max showing on the other without
showing the min if max and max if min what is the easiest way to do
this? thanks
Select Min(Field) As GroupedField
From...
Where...
UNION
Select Max(Field) As GroupedField
From...
Where...

Aug 13 '07 #2

P: n/a
On 13 Aug, 18:31, Salad <o...@vinegar.comwrote:
shaun.co...@uk.gm.com wrote:
I have a form which shows results from a query i have 2 fields one max
and one min there is always 2 records of the same record i want to
have min showing on one record and max showing on the other without
showing the min if max and max if min what is the easiest way to do
this? thanks

Select Min(Field) As GroupedField
From...
Where...
UNION
Select Max(Field) As GroupedField
From...
Where...
What do i put on where and from this is confusing me heheh

Aug 14 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.