H
hfrupn
I need to see all records where the field AssignTo is null or has been
assigned to a specific person. If the checkbox is true all records with null
value AssignTo are displayed. If the textbox [Forms]![frmReview]![AssignedTo]
is null with the checkbox true only the null AssignTo records are displayed
but if there is a value in the [Forms]![frmReview]![AssignedTo] then all null
AssignTo and records with the specific value are displayed.
If both the checkbox and textbox are null all records are displayed and
lastly if the checkbox is false and there is a value in the textbox only
those specific records are displayed.
I have tried the following SQL but I’m not having much luck.
WHERE
(((qReview03ClosedItems.UserAssigned)=IIf([Forms]![frmReview]![NotAssigned]=True,(qReview03ClosedItems.UserAssigned)
Is Null,"") Or
(qReview03ClosedItems.UserAssigned)=[Forms]![frmReview]![AssignedTo])) OR
((([Forms]![frmReview]![AssignedTo]) Is Null));
I would really appreciate any assistance.
Nick
assigned to a specific person. If the checkbox is true all records with null
value AssignTo are displayed. If the textbox [Forms]![frmReview]![AssignedTo]
is null with the checkbox true only the null AssignTo records are displayed
but if there is a value in the [Forms]![frmReview]![AssignedTo] then all null
AssignTo and records with the specific value are displayed.
If both the checkbox and textbox are null all records are displayed and
lastly if the checkbox is false and there is a value in the textbox only
those specific records are displayed.
I have tried the following SQL but I’m not having much luck.
WHERE
(((qReview03ClosedItems.UserAssigned)=IIf([Forms]![frmReview]![NotAssigned]=True,(qReview03ClosedItems.UserAssigned)
Is Null,"") Or
(qReview03ClosedItems.UserAssigned)=[Forms]![frmReview]![AssignedTo])) OR
((([Forms]![frmReview]![AssignedTo]) Is Null));
I would really appreciate any assistance.
Nick