FILTER REPORTS USING MULTIPLE CRITERIA

[Guest]

hi, can u help me how to filter reports using several criteria in a FORM..

i am using comboboxes and checkboxes to filter my report. My problem is
when it comes to checkboxes.

example:

checkbox1 = monday
checkbox2 = tuesday
checkbox3 = wednesday
checkbox4 = thrusday
checkbox5 =friday

How am I goin to filter my report, like - MONDAY and TUESDAY....or MONDAY,
WEDNESDAY and FRIDAY .. or by all...

thanks

amsuria

 

[Guest]

Can you help us by providing some information about your data? Are you
actually storing a value like "Monday" in your table? Do you have some field
names to share?

 

[Guest]

actually, i am creating a database for "Construction PROJECTS"...

it goes like this:
I have a form where a user can filter REPORT to generate using different
attributes like LOCATION, BUDGET, START DATE, END DATE and PROJECT STATUS...

PROJECT STATUS are:
- DESIGN
- PLANNED
- CONSTRUCTION
- AWARDED
- COMPLETED
- ON HOLD

now, what i want to do is to filter my report using multiple attributes..
like for example, I want to filter all the PROJECTS in USA where PROJECT
STATUS are equal to "DESIGN", "CONSTRUCTION" and "ON HOLD"...

I used checkboxes for PROJECT STATUS so that I can choose one or more than
one status...

how am i goin to do such logic.. i cant really think any way to do such
because it is my first time to program in ACCESS (tho im styarting to enjoy
it now)...

thank you and hope you can help me with this..

Amsuria

 

[Guest]

You should probably use a multiple select list box since it will
automatically update when/if you change status values. There are lots of
examples on how to limit a report output based on a multi-select list box.
One can be found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.