HOWTO change query label in datasheet view

  • Thread starter Thread starter Kevin L
  • Start date Start date
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 (e-mail address removed)
 
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 (e-mail address removed)
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"?
 
Back
Top