469,271 Members | 1,466 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

Inserting expression into a query

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 value
like "value1" but if the field has an expression as a value like "value1 or
value2" then the query returns nothing. Is there a way to insert the literal
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
Nov 12 '05 #1
1 1392
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" <Jo**@nospam.infovis.co.uk> wrote in message
news:40***********************@news-text.dial.pipex.com...
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 value like "value1" but if the field has an expression as a value like "value1 or value2" then the query returns nothing. Is there a way to insert the literal 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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by bockley | last post: by
2 posts views Thread by Mike Turco | last post: by
7 posts views Thread by John Øllgård Jensen | last post: by
28 posts views Thread by Marc Gravell | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.