Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft.access.courses - Excel

microsoft.access.courses - Excel

ResolvedVersion Standard

Mon 23 Apr 2007, 09:45 Delegate Angela said...

Angela has attended:
Access Introduction course
Access Intermediate course

Excel

How canI filter out multiple entries (eg list of names with several entries for each name ) in a column to produce a single list of names (ie each name only once?

Mon 23 Apr 2007, 10:09 Trainer Richard said...

RE: Excel

Angela,

You can do this by creating a Query and GROUPING the fields you want to filter.

Once you have created the query with the table in it, showing the field you want to group, then click on the SIGMA or Greek E on the toolbar. This looks like the Autosum button on Excel.

This adds a new row to the query with the words Group By in it.
This will group the records.

Regards
Richard

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips

microsoft.access.courses - Excel

Excel

RE: Excel

Access articles

Access tip:

Splittng a database