Reports based on criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I want to create reports as per users selections. I want to be able to do
text searches across multiple fields (some are drop down andother are check
boxes) so that I can pick and choose the criteria for a report. Essentially,
I would like to perform searches on multiple fields of my choosing.

Your help is needed on this.

Thanks in advance
 
If you have a form with a text box "Forms!frmSelect!txtFind" and a table
with fields "Title" and "Description" that you want to search in a query,
you can use a where clause like:
WHERE [Title] & [Description] Like "*" & Forms!frmSelect!txtFind & "*"
 
Duane,

This works great. In my table..I have checkboxes stored as check marks or
null. Which stores values as -1 and 0.

1. Is there any way I can store them as Yes for -1 and No for 0 values?
Because it would be easier for the user to enter Yes or No.

2. So..in the dialog box where user needs to enter the criteria..the text
appears on that box is: "Forms!frmSelect!txtFind ". How can I change this
text to say.."Please enter Job Location" for job location field and so on..

Please do let me know. Thanks again


Duane Hookom said:
If you have a form with a text box "Forms!frmSelect!txtFind" and a table
with fields "Title" and "Description" that you want to search in a query,
you can use a where clause like:
WHERE [Title] & [Description] Like "*" & Forms!frmSelect!txtFind & "*"

--
Duane Hookom
MS Access MVP


Anna said:
Hi,

I want to create reports as per users selections. I want to be able to do
text searches across multiple fields (some are drop down andother are check
boxes) so that I can pick and choose the criteria for a report. Essentially,
I would like to perform searches on multiple fields of my choosing.

Your help is needed on this.

Thanks in advance
Click to expand...
Click to expand...
 
1. You should never store data in a format that is driven by what users see.
You can use controls on forms such as option buttons, check boxes, combo
boxes, text boxes,... to convert "controlled" and "flexible" user entry into
any values you want to use in your query.
2. I don't use parameter prompts (see number 1.) but this can be done with:
WHERE [Title] & [Description] Like "*" & [Please enter a job location] & "*"

--
Duane Hookom
MS Access MVP
--

Anna said:
Duane,

This works great. In my table..I have checkboxes stored as check marks or
null. Which stores values as -1 and 0.

1. Is there any way I can store them as Yes for -1 and No for 0 values?
Because it would be easier for the user to enter Yes or No.

2. So..in the dialog box where user needs to enter the criteria..the text
appears on that box is: "Forms!frmSelect!txtFind ". How can I change this
text to say.."Please enter Job Location" for job location field and so
on..

Please do let me know. Thanks again


Duane Hookom said:
If you have a form with a text box "Forms!frmSelect!txtFind" and a table
with fields "Title" and "Description" that you want to search in a query,
you can use a where clause like:
WHERE [Title] & [Description] Like "*" & Forms!frmSelect!txtFind & "*"

--
Duane Hookom
MS Access MVP


Anna said:
Hi,

I want to create reports as per users selections. I want to be able to
do
text searches across multiple fields (some are drop down andother are check
boxes) so that I can pick and choose the criteria for a report. Essentially,
I would like to perform searches on multiple fields of my choosing.

Your help is needed on this.

Thanks in advance
Click to expand...
Click to expand...
Click to expand...
 
Back
Top