98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Queries and Relationships
Queries and Relationships
Resolved · Urgent Priority · Version 2007
Mon 31 Mar 2014, 12:35Delegate Jackie said...
Jackie has attended:
Access Intermediate course
Access Advanced course
Advanced Excel Dashboards course
Excel PowerPivot course
Queries and Relationships
We have three tables which have relationship links. Table 1is linked from the primary autonumber key to a foreign key in the Table 2. Table 2 is linked by a separate primary key to a foreign key in Table 3
When we try to run a select query to obtain data from all three tables we get no results. What are we doing wrong?
Mon 31 Mar 2014, 14:14Trainer Jens said...
RE: Queries and Relationships
Hi Jackie,
Thank you for the forum question.
When we are working with databases there can be a lot of reasons why a query isn't returning any records. It is not possible to say what's wrong without having the database in front of you.
If you forward me the datebase I will have look at it.
You can forward the file to info@stl-training.co.uk
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu
Mon 31 Mar 2014, 19:06Trainer Jens said...
RE: Queries and Relationships
Hi Jackie,
Thank you for the database.
I have examined the queries and if you have a look at the Query Visit by Consultant there is no related records.
If you double click the joined line between the tables in the query and select 3: "Include all records from Visit details....." and run the query you can see there is no related records. You can in the field ProjectIDFK relate the Visit Details to the Project details.
I hope this will clarify the issue.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu
Wed 2 Apr 2014, 10:48Delegate Jackie said...
RE: Queries and Relationships
Hi Jens
Thanks I realise now we had not completed the foreign key column with the respective id number form the linked data table. I have now done this and it works! :) Just a simple thing but was really frustrating. Thanks very much.
Jackie & Penny
Wed 2 Apr 2014, 11:54Trainer Jens said...
RE: Queries and Relationships
Hi Jackie,
I am happy to hear that you solved the problem.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu
Wed 9 Apr 2014: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Compact database automoaticallyTo ensure optimal performance, you should compact and repair your |
