Display fields value on report

[GelC]

Hi all,

I created a report which has fields from a relational database. Most of fields I want on the report are displayed as desired except for this two:

1. Position (value list with two columns)
0;"";1;"Open";2;"Closed"

2. Duty (select value from another table)
SELECT tblUsers.UserID, tblUsers.fullName FROM tblUsers UNION SELECT 0 as UserID, " " as fullName FROM tblUsers ORDER BY fullName;

These 2 fields appear on my report like this
Position Duty
1 12
0
1 26
2

I want them appear like
Position Duty
Open James
(blank) Amy
Open Linda
Closed (blank)

Do I have to create two new tables for these two fields.
Please help

Bee

 

[Remou]

You can use a combobox and value list for position and a combobox and sql string for duty. You can just change the controls to combos and fill in the details (make sure you change the names of the controls when you change), or you can use the wizard to create the combos.