G
Guest
I am a new Access user. I've created a database for an academic conference
that contains everything related to the logistics of the event (speakers,
rooms, times, dates, paper titles, abstracts, panel information, and much,
much more). I'm trying to get a report sorted in such a way that it goes in
the following order:
Panel Number [panel number assigned to each panel] ([Panel title])
[Speaker last name], [speaker first name] ([Professional Affiliation])
[Paper Title]
[Paper Abstract/Summary]
The problem that I'm having is the Panel Number expression - it's set up as
a text field because of the added parts (the words "panel number" and the
panel title in parenthesis from another field) and I want it to sort in
numerical order based on the panel number. Now it's sorting in alphabetical
(ie - panel 19 comes before panel 2). I've explored the MS help and tried
using the "Val" feature, but can't get it to work right. Does anyone have
any suggestions?
Beth
that contains everything related to the logistics of the event (speakers,
rooms, times, dates, paper titles, abstracts, panel information, and much,
much more). I'm trying to get a report sorted in such a way that it goes in
the following order:
Panel Number [panel number assigned to each panel] ([Panel title])
[Speaker last name], [speaker first name] ([Professional Affiliation])
[Paper Title]
[Paper Abstract/Summary]
The problem that I'm having is the Panel Number expression - it's set up as
a text field because of the added parts (the words "panel number" and the
panel title in parenthesis from another field) and I want it to sort in
numerical order based on the panel number. Now it's sorting in alphabetical
(ie - panel 19 comes before panel 2). I've explored the MS help and tried
using the "Val" feature, but can't get it to work right. Does anyone have
any suggestions?
Beth