How to use like in a report filter

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

Guest

I have a form that allows the printing of reports based on criteria entered.
Works great when criteria is fully =.
Need to have the ability to use a LIKE statement in the filter of the report
from the criteria entered. For instance, there are sessions A1, A2, A4. User
wants all "A" sessions.
What would be the filter in the report that would accept a LIKE - as in
SQL's Like?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter Report from a ComboList list 2
Select Report Fields based on filtered form 0
Report filter question 1
Filtering subreports on main report 0
SendObject report with a filter 6
Filter report using query 4
A2007 Report not evaluating Where Condition 3
Access Access Report Works on One Machine but not Another 3

Back
Top