RE: FILTER REPORTS USING MULTIPLE CRITERIA

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.

--
Duane Hookom
Microsoft Access MVP


"amsuria" wrote:

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
---------------------------------------------



"Duane Hookom" wrote:

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?

--
Duane Hookom
Microsoft Access MVP


"amsuria" wrote:

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
.

Relevant Pages

  • Re: Filter by Form...How can the Report Reflect the Filter?
    ... If you want a check box to select multiple records, you need a yes/no field in your table. ... If you want to select the fields to filter by, the best solution might be to provide unbound search boxes for each relevant field, and then build the filter string from only those boxes where the user actually entered something. ... substituting your report name instead of Report1. ...
    (microsoft.public.access.forms)
  • RE: FILTER REPORTS USING MULTIPLE CRITERIA
    ... what i want to do is to filter my report using multiple attributes.. ... I used checkboxes for PROJECT STATUS so that I can choose one or more than ... "amsuria" wrote: ...
    (microsoft.public.access.formscoding)
  • Re: 2 intances of the same report
    ... The reason I want to open multiple insances is not for filtering - ... It's the same report exactly, only I need to change some captions on the ... Filter of each instance in its Open event. ... I tried to use DoCmd.OpenReport but when i write it twice, it still opens ...
    (microsoft.public.access.reports)
  • Re: Filter by Form...How can the Report Reflect the Filter?
    ... Consequently, you will need to set focus to the previous control first, and then activate the filter menu. ... Each client of ours has multiple attributes that we keep track of, ... but when I run the report I may only want Iowa and Minnesota ... I could not find a way to hide the data sheet. ...
    (microsoft.public.access.forms)
  • Re: Using Textbox as filter to open report
    ... I succesfully use multiple combo boxes as filter to open report. ...
    (microsoft.public.access.forms)
Quantcast