Access or Excel

The UK's most regular instructor-led training courses.
Training information: microsoft access training course · Access course microsoft training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Access or Excel

Robert has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course

by - delegate Robert [4 posts] (2008 Mar 11 Tue, 13:34) Reply

If I have two databases of addresses (including many duplicates between the two) and I want a report of which addresses DO NOT appear in both, how would I do this?

Thanks Robert

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 4 Thu + 5 Fri	Southwark	0	FULL
2003	2008 Oct 20 Mon + 21 Tue	Southwark	6	book now	£450	£485
2003	2008 Nov 6 Thu + 7 Fri	Southwark	7	book now	£345	£399
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 15 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Access or Excel

by - trainer Richard platinum contributer [785 posts] (2008 Apr 8 Tue, 15:05) Reply

Hi Robert

I would recommend Access for this job. the reason is that the querying power in Access is much more powerful that in Excel.

To start, i suggest having the two lists in two separate tables.

The simple way to check for records that do not exist in another table, is to use the NEW QUERY BUTTON in the Query section of the database window. This will allow you to start a wizard for an UNMATCHED QUERY.

Essentially the wizard will ask you to specify two tables, and the fields to compare. It will then build a query that shows you records that do not appear in the other table.
Do this twice, once for each table, compared to the other.

If you then take these two tables and make one table out of them, you should have a list of addresses that DO NOT appear in both.

Let me know how you go.

Regards

Richard
Microsoft OFfice Specialist

· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Tips for designing databases in Microsoft Access
· Microsoft Access Training Opens Doors
· MS Access: Access your Personal Information with Ease
· Why consider Access Visual Basic training?

Please browse our web site to find out more about
microsoft access training course and other Microsoft training courses.

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips