Editing Joined Querys

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));
 
S

S.Clark

Barring any permissions issues, you should be able to open the
'qReview03ClosedItems' query in design view.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checkbox & Textbox Used As Criteria For A Query 4
Query based on 3 querys 1
Check Box Option in joined query 3
Join on a UNION query 2
Updateable querie 2
Inconsistent return 1
not-equal, theta join 1
Help! Need to update linked SQL table in Acc07 3

Top