open report with where condition

[hasanrazaj1]

hey to all.

i have report form such as...

here i want that user can open report filtered by account name as well as filtered by date range.

firstly if he select a report "Account Report" then he can select a account from combo box to show its report, otherwise leaving blank both combo boxes report will show all account summary.

after that he will give a date range and report will open from start date only or from start to end date or only to end date.

i try it with vb code and now i able to apply all two facilities separately, such as if i supply combo boxes criteria to docmd.open report "Where Condition" argument then it works ok. and if i supply only date range criteria to docmd.open report "Where Condition" argument then its also works ok. but i want to give both criteria of combo boxes and date range to where condition.

i am stuck here so many days.

any suggestion will be appreciated.

 

[RuralGuy]

There is an example of multiple criteria at the bottom of this link: http://www.mvps.org/access/general/gen0018.htm