ms access training - Union Queries

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

Resolved · Low Priority · Version Standard

Union Queries

Navinder has attended:
Access Intermediate course
Access Advanced course

by - delegate Navinder [2 posts] (2007 Mar 6 Tue, 09:43) Reply

How do I remove duplicates from a union query

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 47 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Union Queries

by - trainer David gold contributer [428 posts] (2007 Mar 12 Mon, 10:00) Reply

Hi Navinder

Sorry for the delay in getting back to you. I believe I have just answered this question in your second post. The URL for this answer is:
http://www.microsofttraining.net/post-2113-duplicates.html#2113

I hope this answers your question
David

· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Why go on a Microsoft Access Training Course?
· Microsoft Access 2007: New Features
· Microsoft Access: Unleash the True Potential Today
· Three Myths About Microsoft Access

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips