ms access training - Union Queries

Resolved · Low Priority · Version Standard

Tue 6 Mar 2007, 09:43 Delegate Navinder said...

Navinder has attended:
Access Intermediate course
Access Advanced course

Union Queries

How do I remove duplicates from a union query

Mon 12 Mar 2007, 10:00 Trainer David said...

RE: Union Queries

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:
https://www.stl-training.co.uk/post-2113-duplicates.html #2113

I hope this answers your question
David

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips

ms access training - Union Queries

Union Queries

RE: Union Queries

Access articles

Access tip:

Switchboard Startup