Search results

When I first designed the creation of the query, I used %, but that did not work. The only way that I could get the query to work with the Like statement was to use *. I tested the recordset per your suggestion and you are correct. At the point in the code where it calls the query it shows...

The reason that you do not see the entire structure of the query in the code is because it is being created on the click of a button on a previous form. The select statement that is being created for the query is shown below. This query is being custom built for each user based upon the...

I have a form that displays records based upon user defined values. This form has a button that allows the user to send the data to an Excel file. This works great until the query uses LIKE in the select statement. The only data that is showing up in the Excel spread sheet are the field names...