chineloogbonna
Registered User.
- Local time
- Yesterday, 20:26
- Joined
- Jul 30, 2018
- Messages
- 65
Hello,
I am trying to figure out how to run a Distinct Query for a particular fields BUT also show the other fields.
Basically, I have a listbox that populates a query where fields 1 to 5 are the same but fields 6 to 10 may have different values.
I would like my listbox to show only Distinct records for fields 1 to 5 but I would like the query to populate all fields 1 to 10 so I may use the column values in textboxes on the form.
Not sure if this is doable with a query or if I have to create 2 tables and do a JOIN?
Thank you!
I am trying to figure out how to run a Distinct Query for a particular fields BUT also show the other fields.
Basically, I have a listbox that populates a query where fields 1 to 5 are the same but fields 6 to 10 may have different values.
I would like my listbox to show only Distinct records for fields 1 to 5 but I would like the query to populate all fields 1 to 10 so I may use the column values in textboxes on the form.
Not sure if this is doable with a query or if I have to create 2 tables and do a JOIN?
Thank you!