Parameters with more than one column [message #145455] |
Thu, 03 November 2005 04:24 |
orahugo
Messages: 32 Registered: October 2005 Location: England
|
Member |
|
|
Heya,
I have a parameter called :p_day which has a select statement similar to the following:
select id, description
from days
So, obviously, I'm selecting two columns; the unique ID for the day and the description of the day (i.e. Monday, Tuesday, Wednesday, etc). When my parameter form runs it shows both columns, which I'm perfect fine with.
However, I have a query for my main report where I want a certain field to equal the value of the second column in the parameter (in this case the description).
Currently my WHERE clause is something like the following:
WHERE
appointment.day = :p_week
But I want it to point to the second column.
Is this possible? Many thanks.
|
|
|