Advanced queries by form

[DK22]

Hello,

I have one table named Entry. This table have account number,work organization, price, date and etc.

I use a combo boxes in form which is connected to query and I can easily choose one account number,one work organization and date to see an report. There is also a possibility to left some of the fields blank, it will bring report if is null.

Now I need to make a form that have a possibility to bring up a report for multiple selections of account number and work organization?

Any ideas? Thanks.

 

[jdraw]

It seems you may not have the proper structure to represent your "business problem".
See this tutorial and see if it helps in designing your database.
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

 

[DK22]

Ok, I have a 3 tables which have their relationships. Every kind of query work perfectly, so If I choose one organization and one account number, report will came up absolutely correctly. Now I just want to put in form two or more organizations and two or more account number and got results for them.

 

[jdraw]

Since you only have 2 posts, I think you should capture a jpg of your tables and relationships - then create a zip file of the jpg an attach it to a post. We really need to see your tables and relationships if we are to be helpful.

 

[DK22]

Here is(in attachment) a sample of my database and form where I begin to create listboxes.