New Record In qeury Even if some Fields Are Blank

  • Thread starter Thread starter ReportTrouble
  • Start date Start date
R

ReportTrouble

OK so I want a new record for every action... however my query is combining
tables.
Query Wanted:
Name Link Email RFI
Tom B 01
Tom C 02
Tom Yes

HOWEVER..This is what I am getting

Name Link Email RFI
Tom B 01 Yes
Tom C 02 Yes

Help?
 
OK so I want a new record for every action... however my query is combining
tables.
Query Wanted:
Name Link Email RFI
Tom B 01
Tom C 02
Tom Yes

HOWEVER..This is what I am getting

Name Link Email RFI
Tom B 01 Yes
Tom C 02 Yes

Help?
Click to expand...

Please let us know the structure and sample data of your tables and the SQL of
your query. It's impossible to tell from what you posted.
 
Back
Top