Access Problem (english)

  • Thread starter Thread starter hakansor
  • Start date Start date
H

hakansor

I have a problem with access that needs to be solved as soon a
possible, I hope you will be able to help.

I have a sheet (table), and in this sheet, there are following field
to which 500 people are recorded:

Name, Surname, Birth_Date, Address1, Address2, Address3

I want to make a query that will result in a list of all record
(people) whose Address1, Address2, Address3 fields contains same valu
(data).
Also the list should be sorted in an order descending according to th
Birth Dates.


For example:
Address1 : Ulus Mah.
Address2 : Turkiye Sk.
Address3 : 4

Let's say this fields are same in 10 records (people), it should make
list starting with the one whose Birth Date is the biggest

hakanso
 
Use the "Find Duplicates Query Wizard" - select queries in the database
window, then click on "New", and then choose "Find Duplicates Query Wizard".
Select the three address fields as "fields that might contain duplicate
information", and select the name and birth date fields when asked if you
want to display additional fields. Finally, open the new query in design
view and add a sort order to the BirthDate field.
 
Back
Top