Tagging Query Results

[Rich_Lovina]

My problem is a query using QBE with the following SQL:


SELECT DEPT228.dept_id, POSCODE228.To, DEPT228.Deptname, GOV609.IT_GLOBAL, GOV609.F21
FROM POSCODE228 RIGHT JOIN (DEPT228 RIGHT JOIN GOV609 ON DEPT228.dept_id = GOV609.Deptcode) ON POSCODE228.Poscode = GOV609.Poscode
GROUP BY DEPT228.dept_id, POSCODE228.To, DEPT228.Deptname, GOV609.IT_GLOBAL, GOV609.F21
HAVING (((GOV609.IT_GLOBAL)=Yes))
ORDER BY DEPT228.dept_id, POSCODE228.To DESC;

Explanation: GOV609 is my main table, joined DEPT228 is a list of 700 departments in up to 600 city locations, IT Global is a boolean operator, joined Postcode TO is a salary range identifier and F21 is the tag I want to update.

The problem, for a newwy at SQL is the query uses 'Totals' to get one IT tagged person per city, which is what I want, BUT:
If I try to update query I lose the 'totals' or if I add the AUTONUMBER, then that totals every record.

Or if I Make table query I also lose the 'totals' option.

Which option or expression will hold the selected query result for the update?

 

[Rich_Lovina]

If I click properties above the query I get only 4 options to change, Where precisely to do I change to 'Distinct'?
My choices are Description, Format, Input Mask and Caption?

 

[Rich]

In the query design mode, there is a button on the toolbar with an arrow beside it marked query, click select from the options given.

 

[Rich_Lovina]

Thanks, that's great.Correct Properties found.
What if I want to select 2 records per DEPT228.DEPT_ID?

 

[Rich_Lovina]

Q153747 creates internal haemmoraging when I tried to run my DeptID with the select SQL function. My opened tables are GOV609, DEPT228 and POSCODE.
Should I set the fields in design as GOV609.surname or GOV609.Deptcode (joined to Dept_ID), then ignore title (since I dont want 1st 2 records with each changing title, but 1st two by highest salary, which is a field called POSCODE.TO, or
Should I put the SQL add-in (Q153747) under Poscode.To?