microsoft access training course - Update Query

Resolved · Low Priority · Version Standard

Wed 28 Nov 2007, 16:48 Delegate Dag said...

Dag has attended:
Access Advanced course

Update Query

How do you ensure a query matching 2 or more feilds in multiple tables has not fed back any duplicates?

Thu 29 Nov 2007, 13:19 Trainer David said...

RE: Update Query

Hi Daq

Firstly if you SQL is structured correctly you shouldn't return too many duplicates. However if you are getting duplicates there is an SQL command called DISTINCT.

Hope this helps
David

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Relationship maps

It is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes

Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

View all Access hints and tips