I have a TABLE named c24. The query statement returns all of the data from the table named c24.
There is a FIELD in table c24 that is ALSO called c24 (poor practice).
By passing the value 'c24' when someone selects "Nursing", I was hoping to use 'c24' in:
my query statement, which works fine, in that it queries the c24 table
my column header, which works fine, in that it displays c24
The problem is that in the table itself, instead of showing values such as 18, 22, 66, 15, etc, it shows merely 'c24'.
I realize it is doing this because the actual value of #SelectedService# is 'c24'.
My question is, how to I indicate in the table that I want the actual value of c24 and NOT the actual value of "SelectedService"???
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
