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 » ms access training - I woul like to know more about connecting relationship?
ms access training - I woul like to know more about connecting relationship?
Resolved · Low Priority · Version Standard
Fri 20 Jul 2007, 09:52Delegate Jeannie said...
Jeannie has attended:
Access Intermediate course
Access Advanced course
I woul like to know more about connecting relationship?
I could not find the way to joint the two or three relating deta to be joint together.
Fri 20 Jul 2007, 10:42
Edited on Fri 20 Jul 2007, 10:42Trainer Richard said...
RE: I woul like to know more about connecting relationship?
Using SQL you can achieve this.
Use a SELECT QUERY to select the data from the different tables and use the UNION command tojoin them together.
So, it looks like this:
SELECT [Table1.field1],[Table1.field2],[Table1.field3],
FROM Table1
UNION
SELECT [Table2.field1],[Table2.field2],[Table3.field3],
FROM Table2
Field 1, 2, and 3 must be the same data type
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:Convert A Form Into A ReportIf there is a form that you want to to save as a report: |
