Recent content by 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.

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

"Totals" query with the Group By on the Customer field and then set a field to get the minimum date? Could you explain that? Not sure what a "totals" query or Group By means. Dean

Good question. What I've done in the past is run it thru my address correction software so then it wouldn't be a problem. Unless I'm just lazy and don't care of a few cases such as that. So No and maybe? :)

Forgot this editor does not recognize my spacing. There are two key fields: "address" and say "date rental property bought" so look at the previous post and the 123 main is under the address field and the date refers to the other field. I assume you figured that out but wanted to clarify.

I'm trying to compare the address to find duplicates. So once I find duplicates I can mark that record as a duplicate so I can deal with it later. Bascially here is what I'm doing: First I sort in ascending order address and then in decending order the date the rental property was bought, ie...

I can use auto numbers but maybe not primary key unless I have the auto numbers the primary key. Dean

In MS Access 2007 on the query tab: What I'm trying to do is compare the value in one field to the next value in the same field. So the query would look something like: Field: address table: customer update to: criteria: address + 1 So I'm comparing the address to the next...