H
hfrupn
I have a query that has two queries linked via their ID’s from two separate
tables.
Is it possible to be able to edit the main query?
SQL below:
SELECT qReview03ClosedItems.SADID, qReview03ClosedItems.SADTypeID,
qReview03ClosedItems.DateEntered, qReview03ClosedItems.DateCompleted,
qReview03ClosedItems.DateToBeCompleted,
qReview03ClosedItems.DateToBeCompletedReminder,
qReview03ClosedItems.UserAssigned, qReview03ClosedItems.UserEnteredBy,
qReview03ClosedItems.UserCompletedByID, qReview03ClosedItems.Initator,
qReview03ClosedItems.InitatorSource, qReview03ClosedItems.Description,
qReview03ClosedItems.Notes, qReview03ClosedItems.Priority,
qReview03ClosedItems.ITNumber, qReview03ClosedItems.Selected,
qReview03ClosedItems.Closed, qReview03ClosedItems.File,
qReview03ClosedItems.Object, qCountOpenActions.Actions
FROM qReview03ClosedItems LEFT JOIN qCountOpenActions ON
qReview03ClosedItems.SADID = qCountOpenActions.SADID
WHERE
(((qReview03ClosedItems.UserAssigned)=[Forms]![frmReview]![AssignedTo])) OR
((([Forms]![frmReview]![AssignedTo]) Is Null));
tables.
Is it possible to be able to edit the main query?
SQL below:
SELECT qReview03ClosedItems.SADID, qReview03ClosedItems.SADTypeID,
qReview03ClosedItems.DateEntered, qReview03ClosedItems.DateCompleted,
qReview03ClosedItems.DateToBeCompleted,
qReview03ClosedItems.DateToBeCompletedReminder,
qReview03ClosedItems.UserAssigned, qReview03ClosedItems.UserEnteredBy,
qReview03ClosedItems.UserCompletedByID, qReview03ClosedItems.Initator,
qReview03ClosedItems.InitatorSource, qReview03ClosedItems.Description,
qReview03ClosedItems.Notes, qReview03ClosedItems.Priority,
qReview03ClosedItems.ITNumber, qReview03ClosedItems.Selected,
qReview03ClosedItems.Closed, qReview03ClosedItems.File,
qReview03ClosedItems.Object, qCountOpenActions.Actions
FROM qReview03ClosedItems LEFT JOIN qCountOpenActions ON
qReview03ClosedItems.SADID = qCountOpenActions.SADID
WHERE
(((qReview03ClosedItems.UserAssigned)=[Forms]![frmReview]![AssignedTo])) OR
((([Forms]![frmReview]![AssignedTo]) Is Null));