Hello.
I've created a DAILY report to show data (text) entered into a table and I need help with it.
The text box in the report currently has the following formula:
=[P1.SKU] & " " & [P1.Notes] & Chr(13) & Chr(10) & [P2.SKU] & " " & [P2.Notes]
P1 and P2 aew queries (with criteria) of the original table. The criteria in the query is Date() under the dates field, which only shows entries from today.
I am trying to get the report text box to show only 2 fields from the P! and P2 queries: SKU and NOTES.
The problem I am running into is that when the query or table has no entries I get an ERROR in the report.
I tried =IIf(IsNull([P1.SKU] & " " & [P1.Notes])," ",[P2.SKU] & " " & [P2.Notes]) however it did not resolve the error.
The report also has various other text boxes that are pulling data (also text) from a form that is used to enter data into a different table.
Please help
thank you.