mathsbeauty
Registered User.
- Local time
- Today, 20:45
- Joined
- Apr 14, 2011
- Messages
- 13
Hello! I am new here. This is something interesting and challenging. I doubt whether this is possible in access or not. I have a table in access containing a field for students name and another 10 fields for marks in 10 subjects. A student has appeared exactly for 5 subjects out of 10. Now in a report I want to display exactly 5 subjects with marks for which student has appeared i.e.the problem is to display the first five non-empty fields out of 10. I hope to get some help from experts.