Trying to Print a record on a Form. It works for all records that have something in all three fields, but fails when one of the fields contains nothing. Is there someway without putting Null checks everywhere to have this query work with the existing displayed record on a form. Or is there a better way to do this in code!
sample SQL query
SELECT DIRECT.*
FROM DIRECT
WHERE (((Direct.[Last Name])=[Forms]![Directbus].[Last Name])) and (((Direct.[First Name])=[Forms]![Directbus].[First Name])) and (((Direct.[Business Name])=[Forms]![Directbus].[Business Name]))
ORDER BY DIRECT.[Last Name], DIRECT.[First Name];
DIRECT is the database, Directbus is the current active form being displayed. Any one of these three fields could be blank.
sample SQL query
SELECT DIRECT.*
FROM DIRECT
WHERE (((Direct.[Last Name])=[Forms]![Directbus].[Last Name])) and (((Direct.[First Name])=[Forms]![Directbus].[First Name])) and (((Direct.[Business Name])=[Forms]![Directbus].[Business Name]))
ORDER BY DIRECT.[Last Name], DIRECT.[First Name];
DIRECT is the database, Directbus is the current active form being displayed. Any one of these three fields could be blank.