Duplicate query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I used a Find duplicate query to find students with the same address. Is there any way to assign the students with the same address a unique family number. So in other words, once it finds the students with a duplicate address could I run a script that would give them a unique family numbe

Thanks
Jennife
 
Hi,

I used a Find duplicate query to find students with the same address. Is there any way to assign the students with the same address a unique family number. So in other words, once it finds the students with a duplicate address could I run a script that would give them a unique family number

Thanks
Jennifer
Click to expand...

Hi Jennifer,

This would take some VBA code to do; I don't know of a simple script
that would accomplish it. Anyway, you would still end up with duplicate
address data, which is not what you want in a relational database.

The proper way to do this is to have a Household or Family table, which
contains the address. Then, each Student can belong to that Household.

--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com
 
Back
Top