Reports..need help

[Guest]

Hi,

I have a field for "job location" which is drop down. So here I can create a
report based on the criteria. Like when user click report for the job
location..pop-up window will appear so that user can enter job location
keyword and it will create its own report for that location. So..this is
possible with the srop down field.

Can we do the same thing..(based on query/criteria) for check boxes field.
Because I have check boxes for education and want to create same kind of
report so that user has flexibility create as per his/her own requirement.

Please help me. I would appreciate your help.

Thanks

 

[John Vinson]

Hi,

I have a field for "job location" which is drop down. So here I can create a
report based on the criteria. Like when user click report for the job
location..pop-up window will appear so that user can enter job location
keyword and it will create its own report for that location. So..this is
possible with the srop down field.

Can we do the same thing..(based on query/criteria) for check boxes field.
Because I have check boxes for education and want to create same kind of
report so that user has flexibility create as per his/her own requirement.

The simplest way to do this is to create an unbound Form with whatever
controls - combo boxes, checkboxes, etc. - you need for the criteria.
Create a Query with criteria like

=[Forms]![frmCrit]![cboJobLocation]

This will look at the selected value of the combo box named
cboJobLocation on the form named frmCrit (which must be open at the
time).

It's handy to base a Report on this query, and put a command button
onto frmCrit to open the Report. That way it's not necessary to "run"
the query at all; the user opens the Form, enters the criteria, clicks
a button and the report prints (or previews if you set it up that
way).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

John,

I tried doing the way you said for "job Location" which is dropdown field.
Its working fine for this field. But its not working for check boxes. The
check boxes I have in the table are Yes/No type. So in the table data is
stored as check mark or blank. So when the criteria window pop-ups for one
check box what should be entered to get the query run. I tried entering Yes
or True..its not working.

Your help is needed on this. Thanks

Hi,

I have a field for "job location" which is drop down. So here I can create a
report based on the criteria. Like when user click report for the job
location..pop-up window will appear so that user can enter job location
keyword and it will create its own report for that location. So..this is
possible with the srop down field.

Can we do the same thing..(based on query/criteria) for check boxes field.
Because I have check boxes for education and want to create same kind of
report so that user has flexibility create as per his/her own requirement.

The simplest way to do this is to create an unbound Form with whatever
controls - combo boxes, checkboxes, etc. - you need for the criteria.
Create a Query with criteria like

=[Forms]![frmCrit]![cboJobLocation]

This will look at the selected value of the combo box named
cboJobLocation on the form named frmCrit (which must be open at the
time).

It's handy to base a Report on this query, and put a command button
onto frmCrit to open the Report. That way it's not necessary to "run"
the query at all; the user opens the Form, enters the criteria, clicks
a button and the report prints (or previews if you set it up that
way).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps