In a database I have a field for Name. I need for the field to contain both the first and last names. I enter the data like this - Dean John. I tried using a comma in between but Access does not like this. I have a form based on a query to launch a report. The query looks for the contents of the Name field on the form to filter the report. In the query, I am using the following code
The problem is, when I select a name and run a report I get no data. However if I run a regular query and type in the name in the criteria field it returns the data. I have done this numerous times with other fields and it works, so I am not sure why it's not working for this. The data type is Text.
Any suggestions?
Jim
Code:
[Forms]![frm_Main]![cbo_Name] Or Like [Forms]![frm_Main]![cbo_Name] & "*"The problem is, when I select a name and run a report I get no data. However if I run a regular query and type in the name in the criteria field it returns the data. I have done this numerous times with other fields and it works, so I am not sure why it's not working for this. The data type is Text.
Any suggestions?
Jim
