Report both with and without detail sections

[g.vanswaaij]

Dear all,

I am currently working on a database which dynamically generates
questions based on a table questions. This table contains both open
questions and multiple choice questions. For the multiple choice
questions, all possible answers are stored in a related table
'answers'. Now I would like to create a report which contains both the
open questions and the multiple choice questions with all the possible
answers. The problem is: Access bases the report on one query which
selects only those questions with related records in the table answers,
so not the open questions. Does anyone have a solution for this?

By the way, the current data source for the report basically boils down
to this: (Antwoord means answer and Vraag means question in Dutch)

SELECT [Antwoord].[omschrijving] AS Antwoord_omschrijving,
[Vraag].[omschrijving] AS Vraag_omschrijving, [Vraag].[ID] AS Vraag_ID,
FROM Vraag INNER JOIN Antwoord ON [Vraag].[ID]=[Antwoord].[vraagID];

 

[Theo P]

Gebruik als basis voor je rapport een query met een OUTER JOIN ipv een INNER
JOIN.
succes
Theo

 

[g.vanswaaij]

Thanks, but is the syntax of OUTER JOIN supposed to be the same as
INNER JOIN? I tried your solution, and Access just gave a syntax error
(even in a very basic test query). Additionally, my version of the
help file doesn't say anything about OUTER JOIN. So I'm afraid that
Access doesn't support this join.

Gijs van Swaaij

Gebruik als basis voor je rapport een query met een OUTER JOIN ipv een INNER
JOIN.
succes
Theo

Dear all,

I am currently working on a database which dynamically generates
questions based on a table questions. This table contains both open
questions and multiple choice questions. For the multiple choice
questions, all possible answers are stored in a related table
'answers'. Now I would like to create a report which contains both the
open questions and the multiple choice questions with all the possible
answers. The problem is: Access bases the report on one query which
selects only those questions with related records in the table answers,
so not the open questions. Does anyone have a solution for this?

By the way, the current data source for the report basically boils down
to this: (Antwoord means answer and Vraag means question in Dutch)

SELECT [Antwoord].[omschrijving] AS Antwoord_omschrijving,
[Vraag].[omschrijving] AS Vraag_omschrijving, [Vraag].[ID] AS Vraag_ID,
FROM Vraag INNER JOIN Antwoord ON [Vraag].[ID]=[Antwoord].[vraagID];

 

[g.vanswaaij]

Nevermind, I found the correct syntax. Thanks a lot for the help!