HOWTO change query label in datasheet view

K

Kevin L

I have numbers 01 - 32 with scheduled and completed in a
linked table. When the query runs, it shows

01-scheduled
01-completed
etc.

I would like to change the 01 to the real meaning ie.
Retainer-Sheduled for 01, etc.

I can not figure out how to build the expression in
Design View to properly change once the query runs.

either respond here or e-mail to [email protected]
 
J

John Vinson

I have numbers 01 - 32 with scheduled and completed in a
linked table. When the query runs, it shows

01-scheduled
01-completed
etc.

I would like to change the 01 to the real meaning ie.
Retainer-Sheduled for 01, etc.

I can not figure out how to build the expression in
Design View to properly change once the query runs.

either respond here or e-mail to [email protected]
Click to expand...

Please post the SQL of your query, and describe the data in "the
linked table". How and where in your database is there a connection
between 01 and "Retainer"?
 
Top