Difficult design query help needed!!

[Guest]

OK I am definitely stumped on this one. Can anyone suggest a solution for
this problem? I have a form that has a button, when pressed it comes up with
a question “Do you want to change the Anomaly†and allows the user to select
yes or no. If they select yes then a form pops up with a combo box and a
list box. That part was the easy part my difficulty is as follows. The
items I want populated in the combox is from pulling the PractCATID
(categories) from tblPracticalResults. Each person can have anywhere from 70
records on up, but each record has different training requirement
information. Something like the following, but has more columns than shown.
PracticalResultsID PK, PracticalIDNumber FK, PractCatID Number, Attribute
Number, AttDetail Number, Anomaly Y/N. Some of these has AttDetail,
while others just have 0 (no detail)

i.e.
1 5 1 2 2 False
2 5 1 3 2 True
3 5 1 4 0 False
4 5 2 2 4 False
5 5 2 3 2 False
6 5 2 4 1 True
etc.

Each person can have anywhere from 0-4 records that the Anomaly is true, but
only 1 per PractCatID. Also, they can have 4-20 different PracCatID. So what
I am attempting to do is allow the user to change the anomaly if the one they
are trying to grade is no longer needed. This would be easy if they want to
use the same PractCatID. Now they want to allow them to choose which
PractCatID they want, except for the ones that has Anomaly checked yes
already, but also allow them to choose the same PractCatID that they are
editing and Group it so only one PractCatID shows for each item. In other
words I would like 1,2, 3, etc instead of 1,1,1,2,2,3,3,3, etc. Once they
select the PractCatID in the combo box it will populate the list box with the
Anomalies associated with it. Then using a delete query it will delete the
records associated with the one they no longer needed.
Hopefully, this makes some kind of sense. Can anyone assist me on this? I
am dying on this one. My brain is about fried. Thanks a lot in advance.

 

[Guest]

I think I have it, I had to use 2 queries. Can someone else verify this to
see if there is a better way? Thanks whoooooo

SELECT tblPracticalResults.PractCatID
FROM tblPracticalResults
WHERE
(((tblPracticalResults.PracticalIDNumber)=[Forms]![frmEvaluation].[PracticalIDNumber])
AND ((tblPracticalResults.Anomaly)=True) AND
((tblPracticalResults.AttributeDetail)=0) AND
((tblPracticalResults.PointsPossible1) Is Not Null))
GROUP BY tblPracticalResults.PractCatID
HAVING (((tblPracticalResults.PractCatID)<>7 And
(tblPracticalResults.PractCatID)<>[Forms]![frmEvaluation].[txtCATID]));

SELECT tblPracticalResults.PractCatID, tblCategory.Category
FROM qrySelectPracAnomaly, tblCategory INNER JOIN (tblPracticalCategory
INNER JOIN tblPracticalResults ON tblPracticalCategory.PRACTCATID =
tblPracticalResults.PractCatID) ON tblCategory.CATID =
tblPracticalCategory.CATID
WHERE
(((tblPracticalResults.PractCatID)<>[qrySelectPracAnomaly].[PractCatID]) AND
((tblPracticalResults.PracticalIDNumber)=[Forms]![frmEvaluation].[PracticalIDNumber])
AND ((tblPracticalResults.Anomaly)=False) AND
((tblPracticalResults.AttributeDetail)=0) AND
((tblPracticalResults.PointsPossible1) Is Not Null))
GROUP BY tblPracticalResults.PractCatID, tblCategory.Category;