RE: FILTER REPORTS USING MULTIPLE CRITERIA

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 REPORTS USING MULTIPLE CRITERIA
    ... examples on how to limit a report output based on a multi-select list box. ... 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 ...
    (microsoft.public.access.formscoding)
  • Building a SQL string
    ... The project manager want the user to select names using checkboxes. ... Then run a report with those names as filter. ... I was thinking of accomplishing this by using DAO to loop through the ...
    (microsoft.public.access.modulesdaovba)
  • RE: Filter Filter Filter
    ... The technique is to filter each combo based on the value selected in the ... you would requery the Budget Combo in the After Update of the ... Now, once all the selections are made and you wan't the report, use the ... "amsuria" wrote: ...
    (microsoft.public.access.formscoding)
  • Re: Filter for Report not working?????
    ... Do I need to release the filter or close the TableFame? ... contFilter DynArrayString ... Your first example based on ContractNo ... I decided to go with a table in PRIV for the report. ...
    (comp.databases.paradox)
  • Re: Show all records through combo box
    ... I should not have used the term report to describe what it is I ... was refering to is a MCReport. ... the subforms to the main form using the Company_ID and the MCReport_ID. ... There is no code in the filter section. ...
    (microsoft.public.access.forms)
Quantcast