Having multiple values from a form field as criteria for a query

J

jordy

I have a fairly simple database with two tables, which are sharepoint lists.

in one of the tables i have several fields, where multiple values are
possible, entered through comboboxes.

I'm trying to build a query where all the criteria are being inserted
through a form. there is a form where names, dates, etc can be typed and that
are the criteria for the query. as long as it is text, dates, numbers,
everything works fine.
if i use one of the fields with multiple values it is ok too, as long as i
only allow one item selected (one value).

as soon as i allow multiple values it doesn't work anymore. hopelfully my
explanation is clear and someone knows the answer.

thanks,
Jordy
The Netherlands
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Creating a Chart on form from selected data in query. 0
Copy previous record into form field 0
ASK Field Formatting 1
Using project as a resource tracker 0
Page numbering with Merged Document and IF statements 1
execute query from a form connected to sharepoint 0
Access 2010 DB not fuctional with multiple users 2

Top