T
TotallyConfused
I would appreciate any help with the following. I have identified duplicate
rows per address field. Now I need to create a query that will flag in a
field (Main with a Y, N) go through these duplicate rows and keep only the
row that has duplicate address, city, state and looks at the age to keep the
row with the older age. If age is the same for both rows than look at the
gender field, if gender field is the same than choose only the first row.
Does this make sense? Thank you for any help you can provide.
rows per address field. Now I need to create a query that will flag in a
field (Main with a Y, N) go through these duplicate rows and keep only the
row that has duplicate address, city, state and looks at the age to keep the
row with the older age. If age is the same for both rows than look at the
gender field, if gender field is the same than choose only the first row.
Does this make sense? Thank you for any help you can provide.