C
Catherine
Hi everyone,
I hope you can help. I have a query with 5 different
fields of info which look like this:
LessonA, LessonB, LessonC, LessonD, LessonE
5 7 19
2 4
and so on. What I need to do is combine the fields so
they will look like this: 5, 7, 19 or 2, 4 in a report.
I've tried IIf(IsNull) to build an expression but the
result ends up: 5, 7, 19, ,
Help! Is there a another/simple way to do this? Thanks so
much!
I hope you can help. I have a query with 5 different
fields of info which look like this:
LessonA, LessonB, LessonC, LessonD, LessonE
5 7 19
2 4
and so on. What I need to do is combine the fields so
they will look like this: 5, 7, 19 or 2, 4 in a report.
I've tried IIf(IsNull) to build an expression but the
result ends up: 5, 7, 19, ,
Help! Is there a another/simple way to do this? Thanks so
much!