Recent content by 6thDAY
-
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...