one to many

[Guest]

Is it possible to do the following:

set up a one to many query that when there is no record in the many table
generate a blank value instead, so that the result would look like this

Result is:

A
B
C
"BLANK ENTRY"
D
E
"BLANK ENTRY"

ie the number ore retrieved records for teh one to many query is the same as
the original "one" table and the blank entries correspond to a record in the
first table where there is no equal record in the second table (the many)

 

[John Vinson]

set up a one to many query that when there is no record in the many table
generate a blank value instead

Yes. Select the join line in query design view and select Option 2
"Show all records in <the one table> and matching records in <the many
table>". The SQL syntax is

SELECT <fields>
FROM TableOne LEFT JOIN TableTwo ON...

in place of the default Inner join.

John W. Vinson[MVP]