Simple if you know how...

[Fornatian]

Having helped another reader, I have a related question. I have a multiselect list box with various names for simplicity purposes. Bob,Jane and Freddy.

I also have a fuction that builds a text string from the selections so it returns
'Bob' OR 'Jane' OR 'Freddy'

What I want to know is how do I put this function into a queries criteria row without it treating the whole lot as a text string like "'Bob' OR 'Jane' OR 'Freddy'"

Can someone advise me as to whether this is possible in the QBE grid or would I have to resort to building the SQL string in code?

I know why it's doing it but can't see a QBE led answer.

Ian

 

[mark curtis]

Ian,

Sorry to jump in on your question but I want to create a fuction that builds a text string from the selections from my list box so it returns'Bob' OR 'Jane' OR 'Freddy'and then how to reference that function in a query.

Hope you can help, the question I posted above details what I require.

Thanks again for all your time.
Mark

 

[Fornatian]

Thanks Pat.