P
Paul Dennis
I have 2 tables, one is the main data tables and another an audit table,
hence unless an activity has taken plan will not contain related records to
the main table.
I have created a query on the audit table and then another query which
brings in the main table and the query on the audit table. However since
there isn't a 1 2 1 relationship I am getting #Error is the fielfd relating
to the sub query.
How can I avoid this? Should I use IsNull ? if so how?
hence unless an activity has taken plan will not contain related records to
the main table.
I have created a query on the audit table and then another query which
brings in the main table and the query on the audit table. However since
there isn't a 1 2 1 relationship I am getting #Error is the fielfd relating
to the sub query.
How can I avoid this? Should I use IsNull ? if so how?