Daniel said:
Hi,
I have a list with thousands of rows on an Access 2000 database. One
column is for addresses, and in some cases, an adress can be repeated
many times. I was wondering if there's a way to filter that list in
order to only a have an address appear once, without scrolling down
deleting one by one.
Thank you
Lets start by saying you need to normalize your table structure.
Repeated data is an indication that you need to divide that table into a
parent child relationship pair of tables. Usually in this case the parent
is the name information and the address is the child table. There would be
fewer records (We don't call them rows in a database, it has to do with the
way databases work vs. spreadsheets. We also have fields not columns, again
a difference in the way they work.) in the child table. This reduces the
total size of the database, allows faster operation and a more flexible use
of and access to, the data.
Access has a wizard to help you out doing this. I suggest you take at
look at normalize in the help file.
Now as to your question. Yes it is possible with or without correcting
your table design to DISPLAY the data as you indicate in a report (I think
you may be able to do it in a form as well, but I have not tried). with a
single display of the address followed or proceeded by a list of those names
at that address.
Access is very flexible.
Learning access can be a bit of a challenge at first. It helps to keep
saying over and over again.
"Access is not a spreadsheet!"
You should find some samples of this kind of split table in the
Northwind database example.
