Search results
-
6
Solved Creating a query with unique records using complicated filtering fields?
Excellent, I ran a No Duplicate query and saw none. -
6
Solved Creating a query with unique records using complicated filtering fields?
The results are almost correct except one minor issue. The original Query 1 with GroupID = 20: GroupID MyName Age Rating Animal Mood 20 David 1 1 Leopard Good 20 David 1 2 Cheetah Good 20 David 1 2 Leopard Bad 20 David 1 3 Cheetah Good 20 David 1 3 Leopard Good Your updated... -
6
Solved Creating a query with unique records using complicated filtering fields?
Correct, either the first of the group IIF "all" records are GOOD, or the first BAD of the group. -
6
Solved Creating a query with unique records using complicated filtering fields?
Yes there is, apologies for that: GroupID MyName Age Rating Animal Mood 17 Kevin 1 4 Tiger Good 17 Kevin 1 4 Giselle Good -
6
Solved Creating a query with unique records using complicated filtering fields?
Apologies for bring this solved thread back from the dead, but I modified some records, and it doesn't meet the requirements as we discussed previously. Let me show an example. In the original fixed you made, Query1 looks like so: GroupID MyName Age Rating Animal Mood 17 Kevin 1 1 Lion... -
6
Solved Retrieving the record with the highest column field number value or return "No Value" if exist....
Apologies, I don't follow you in relation to my "hack" solution? -
6
Solved Retrieving the record with the highest column field number value or return "No Value" if exist....
Instead of using 3 queries, I did this: SELECT TOP 1 Color, Purity FROM Table1 ORDER BY CInt(IIF(Purity='No Value',1000,Purity)) DESC; Where 1000 is guarantee to be the highest value even though it will never reach it, and I was able to return the record containing No Value. Is this OK code... -
6
Solved Retrieving the record with the highest column field number value or return "No Value" if exist....
I have a simple table containing sample data like so: Color Purity Red 10 Red 3 Red 9 Red No Value Red 12 Red 11 I'm trying to run a query where if there are multiple of the same Color, pick the record that has the highest Purity value, but ONLY if there doesn't exist a record... -
6
Solved Combo Box Filter Not Filtering Report Correctly in Navigation Form When Using Multiple Reports?
Thanks @arnelgp as always. You saved my day! -
6
Solved Combo Box Filter Not Filtering Report Correctly in Navigation Form When Using Multiple Reports?
I just went through the code in `Form_Form1` and `Form_Navigation Form` and have a couple questions regarding this: 1. Excuse my limited knowledge, but based on what I see and walking through the lines of code in `Form_Form1`, you're essentially filtering the data selected, i.e. `Animal`... -
6
Solved Combo Box Filter Not Filtering Report Correctly in Navigation Form When Using Multiple Reports?
Apologies, I havent had a chance to check it out until now. I'll let you know. Thanks @arnelgp -
6
Solved Combo Box Filter Not Filtering Report Correctly in Navigation Form When Using Multiple Reports?
I have a Navigation Form with 2 buttons, 1 filter combo box, and a subform beneath containing a report. Each button displays a different report in the subform. The combo box filters the same field in both reports. It looks like so: The subform in the Navigation form is linked based on their... -
6
Solved Creating a query with unique records using complicated filtering fields?
Yes we finally got the output correct. Again, I apologize if the requirements were not originally clear. -
6
Solved Creating a query with unique records using complicated filtering fields?
YES it outputs the data as expected. @arnelgp You saved my day ONCE AGAIN! You are the GOAT! -
6
Solved Creating a query with unique records using complicated filtering fields?
Hey @arnelgp, sorry to keep bugging you about this but the same issue still appears on the latest Output: GroupID MyName Age Rating Animal Mood 18 Kevin 2 2 Cheetah Good 18 Kevin 2 3 Cheetah Good 18 Kevin 2 2 Hippo Good There should only be 2 records there. One is Age = 2 -> Rating... -
6
Solved Creating a query with unique records using complicated filtering fields?
Looks almost good except one repeated record. Here is the Output: ID GroupID MyName Age Rating Animal Mood 210 17 Kevin 1 1 Bad 211 17 Kevin 1 2 Bad 212 17 Kevin 1 3 Bad 213 17 Kevin 1 4 Bad 214 18 Kevin 2 2 Good 215 18 Kevin 2 3 Good 216 18... -
6
Solved Creating a query with unique records using complicated filtering fields?
If there are 2 records with the same GroupID where one is Bad and one is Good, and the Age points to the same Rating for both records, then choose the record that is Bad to Output. However, if there are 2 records with the same GroupID where one is Bad and one is Good, but the Age "does not"... -
6
Solved Creating a query with unique records using complicated filtering fields?
This is the Ouput form from your latest: GroupID MyName Age Rating Animal Mood 17 Kevin 1 1 Bad 17 Kevin 1 2 Bad 17 Kevin 1 3 Bad 17 Kevin 1 4 Bad 18 Kevin 2 2 Cheetah Good 18 Kevin 2 2 Hippo Good 19 Kevin 3 1 Bad 19 Kevin 3 2 Bad 19... -
6
Solved Creating a query with unique records using complicated filtering fields?
I changed your Query2 to also Group by Age and Rating, which produces the output I want: GroupID Age Rating CountGood CountBad CountGroup 17 1 1 1 1 2 17 1 2 0 1 1 17 1 3 2 1 3 17 1 4 1 1 2 18 2 2 2 0 2 18 2 3 1 0 1 19 3 1 0 1 1 19 3 2 0 1 1 19 3 3 0 1 1 20 1 1 0 1 1... -
6
Solved Creating a query with unique records using complicated filtering fields?
Hey @arnelgp, appreciate your response with this but the Output table doesnt look quite right. There's only one unique GroupID. Maybe I confused you with my requirements. The same GroupID value can be repeated which is why it's not a Primary Key. Only the "same" Rating cannot belong to the same...