Hi,

I’m trying to create a bibliographic database with MS Access 2013.

I have created a search query form that uses three list boxes with multiple (extended) select. Basically, users should be able to search for articles by year (1991-2013), country, and keyword (i.e. politics, economy). Without multiple select, the search query worked fine, i.e. just clicking one option from each listbox. But now if I click for example 1991 + 1992 and two countries, it returns no records.

I guess this is an issue of entering the correct criteria in the query design.

For example, this is what I have been using for the criteria for the year field, but it doesn’t work:
[Forms]![Search Form 0902]![Year].[MultiSelect]

I’m new to Access 2013 and can’t find the answer to this question.

Would really appreciate any help!

Alec