472,131 Members | 1,464 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,131 software developers and data experts.

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 1440
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.