NickDenyer
Registered User.
- Local time
- Today, 23:32
- Joined
- May 2, 2012
- Messages
- 57
Hi Guys,
I've only been on this forum for a short while but already the answers I have gotten on other questions have been excellent! I've asked two questions now, this is my third, and the only way I'm going to master Access is to keep on asking!!!!!!
So my next question I have a table and an identical query of information, and one of the columns contains names; with some names appearing more than others. I've linked these to a Combo-Box.
Is there any way I can:
1) When opening the combo, it will list names that, for instance, appear 7 times, only once?
2) Then, produce a report (or a form with Fields added, whatever is better/easier) from selecting one name, (that, for example, may have 7 records associated with it) using a GO button, that lists that person's name and ALL the information (e.g. 7 records) associated with that one name???
Much obliged!!! And one day hopefully I'll be able to answer these questions for someone else!
Cheers
I've only been on this forum for a short while but already the answers I have gotten on other questions have been excellent! I've asked two questions now, this is my third, and the only way I'm going to master Access is to keep on asking!!!!!!
So my next question I have a table and an identical query of information, and one of the columns contains names; with some names appearing more than others. I've linked these to a Combo-Box.
Is there any way I can:
1) When opening the combo, it will list names that, for instance, appear 7 times, only once?
2) Then, produce a report (or a form with Fields added, whatever is better/easier) from selecting one name, (that, for example, may have 7 records associated with it) using a GO button, that lists that person's name and ALL the information (e.g. 7 records) associated with that one name???
Much obliged!!! And one day hopefully I'll be able to answer these questions for someone else!
Cheers