| re: Inserting expression into a query
Answered in the sponsored newsgroups. If you feel _compelled_ to post the
same question to multiple newsgroups, please crosspost so the answers will
show up in the newsgroup with the copies of the question. This one was
_multiposted_ separately, so there is no link from that answer to the
question here.
"John" <John@nospam.infovis.co.uk> wrote in message
news:4087119c$0$26188$cc9e4d1f@news-text.dial.pipex.com...[color=blue]
> Hi
>
> I am using a form field as criteria in a query like this
> [Forms]![MyForm]![MyField]. This works fine if the field has a single[/color]
value[color=blue]
> like "value1" but if the field has an expression as a value like "value1[/color]
or[color=blue]
> value2" then the query returns nothing. Is there a way to insert the[/color]
literal[color=blue]
> value of the field "value1 or value2" into the query? I want to do it in a
> way that I can change this expression at runtime.
>
> Thanks
>
> Regards
>
>[/color]
| 
