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