Reports based on contain criteria

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

Guest

I need to have a report prompt for data and then generate the report based on that data. The problem is that I would like the criteria to be if the entered text is in the field anywhere.

i.e. The field contains a Name of 'Bob's Tire Shop'. If you enter Tire for the search criteria, it should be displayed in the Query or Report.

Thanks,

Stephen
 
SKovacsiss said:
I need to have a report prompt for data and then generate the report based on that data. The problem is that I would like the criteria to be if the entered text is in the field anywhere.

i.e. The field contains a Name of 'Bob's Tire Shop'. If you enter Tire for the search criteria, it should be displayed in the Query or Report.
Click to expand...


Set the criteria to

Like "*" & [Enter partial name] & "*"
 
Back
Top