Report based on multiple criteria selections

[Andren]

Hi all !

I have been browsing a lot of topics, searching for an answer on my present question - but i found no clue.

So this is my (current) problem:

I have done a literature database for special litterature.
In one part of that database it is possible for end users to classify reports and litterature beeing put into the database.

Classification is multiple - based on a lot of criteria variables (about 15 variables). Classification comes from list-boxes on a subform putting values in appropriate place in a table.

Now - I want end users to have the opportunity to select a report based on one - or - multiple selections.

How do I do this ? (it's kind of overcourse for my part...).


Thanks.

/ Anders

 

[simongallop]

The easiest way is to create a form where the users select the criteria that they want to report on. This criteria is then passed to a query to limit the number of records and then final report uses the query as its feed

 

[Andren]

Thank you for answering!

I did understand what you wrote BUT - beeing new to the field - how do I do that "passing of criteria" to a query ??

I would apreciate if you could explain that a little bit further.

/ Anders

 

[simongallop]

In the criteria of the specified field in the query type =[Forms]![NameOfForm]![ControlName]

So eg: You have a field in your query called Surname. On the selection form (ReportSelect) you have a listbox called lstSurname. In the criteria of the field Surname in the query design grid: =[Forms]![ReportSelect]![lstSurname]

HTH

 

[Andren]

Multiple search criteria

Harry!
Your advice was most helpful.
HOWEVER - I have encountered a seccond problem.
You see, the codes that i put in my database (and that I want to combine inte multiple search criteria) are coming from several stand alone look-up tables with three columns. Since I am writing an application where end users can pick their language of preference (English or Swedish) I made it this way:
1 Boys Pojkar
2 Girls Flickor
9 Not defined Ej specificerat
On the input-form, end-users will see and pick labels (boys,girls etc) and the apropriate codes will be stored in the database table. Now - I want end-users to pick search criterias from combo-boxes speaking English or Swedih because I can't expect them to remember what all codes are about. Is there a way around this - by writing VBA-code for example. Or could I use my look-up tables again in some way ?

I really appreciate any comment on this.

/ Anders