abidshahzad4u
Registered User.
- Local time
- Today, 19:33
- Joined
- Aug 17, 2009
- Messages
- 15
Hi to all
beginner in access knowledge.
I have two table. SampleTest and TestDetails. As one sample may have many tests. So the tables are in one to many relationship based on sample ID (Autonumber field in sample SampleTest table.).
When I create a report and group it on the basis of sample id. TestName from the TestDetails repeats multiple time. This takes the page down with only record repeating in the test details.
I want to seperate the TestName form TestDetails with comma, not the whole line.
How can I do this?
beginner in access knowledge.
I have two table. SampleTest and TestDetails. As one sample may have many tests. So the tables are in one to many relationship based on sample ID (Autonumber field in sample SampleTest table.).
When I create a report and group it on the basis of sample id. TestName from the TestDetails repeats multiple time. This takes the page down with only record repeating in the test details.
I want to seperate the TestName form TestDetails with comma, not the whole line.
How can I do this?