How do I compare one field to the next?

[Bilbo_Baggins_Esq]

Change the "Group By" to "MAX" or "MIN" in the date field

 

[InDFW]

OMG! THANK Y'ALL SO MUCH!!!
i've been trying to do this for so long - my company is gonna LOOOVE me! wish i could buy y'all a drink!!!

i've always lurked and found the answers i need, but i'm sure i'll be posting more cuz the boss always wants more more more!!! job security

 

[InDFW]

I need to create a report with the max date, Title (in OPs example, this was her Address field), and also include several other fields. When i add other fields, it stops grouping correctly.

I tried creating a query from the query and adding additional fields, and grabbed the fields I needed along with the fields from the new Group By query, but it gives me all of the dates, not just the oldest ones.

Does that explain my problem clearly? If not, would it help if I gave you my specific field categories?

 

[boblarson]

I need to create a report with the max date, Title (in OPs example, this was her Address field), and also include several other fields. When i add other fields, it stops grouping correctly.

I tried creating a query from the query and adding additional fields, and grabbed the fields I needed along with the fields from the new Group By query, but it gives me all of the dates, not just the oldest ones.

Does that explain my problem clearly? If not, would it help if I gave you my specific field categories?

What you need is to create a query from the query and add additional fields BUT you also need to include the date field and link both tables at the date field as well as the primary key.

 

[InDFW]

What you need is to create a query from the query and add additional fields BUT you also need to include the date field and link both tables at the date field as well as the primary key.

worked like a charm.
ty again!

 

[servent1]

I got lost on that last explanation from Bob. Where I left off is adding the address ( I think Bilbo called it the customer field) and the date using the group by and min. It works with just those to fields in the query but when I add fields it's all messed up.

Thanks,
Dean

 

[servent1]

Also, if I can flag a field showing that the owner has multiple properties then
i can mail him later on those. But the oldest rental is the one I first and foremost
want to target. Using the summation and group by and min I don't thinkt that
will work.