Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Showing all items in a table in a query

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Showing all items in a table in a query

Resolved · Medium Priority · Version 2003

Reply Wed 14 Apr 2010, 12:06Delegate Louise said...

Louise has attended:
Access Introduction course

Showing all items in a table in a query

Hi, I'd like to show all 'organisations' from Table1 in my query with Table2 and Table3. There are 563 organisations in Table1, but not all of these are listed in Tables 2 and 3 (since some organisations are recent joiners to our programme). How do I set the criteria in the query to show all organisations from Table1 regardless of whether or not they are in the other tables? Is this possible? Right now, I am adding the organisation where it is missing to the other two tables. Thanks for your help!

For upcoming training course dates see: Pricing & availability

Reply Wed 14 Apr 2010, 16:51Trainer Anthony said...

RE: Showing all items in a table in a query

Hi Louise, thanks for your query. It's a little difficult to advise you without seeing the database you are working with, but I would suggest you double check that the tables are normalised and their relationships are set correctly with primary and foreign keys in place. After that it should be a matter of simply dragging the relevant fields into the query. Your problem certainly sounds like the relationships haven't been set correctly, or your table structures need to be looked at so clarify these first.

Hope this helps,

Anthony

Reply Wed 14 Apr 2010, 16:52Trainer Anthony said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Wed 21 Apr 2010: Automatically marked as resolved.

Access articles

· How To Make Access 2010 Databases Compatible With Access 2007
· Help Business To Go Global With Shared Databases
· A Brief Guide To Table Relationships In Access
· Supersizing your databases via Microsoft Access
· Making The Transition To Access - Why You Might Need It

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

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips