Setting Criteria in Query

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

Guest

I have a query with 3 fields: Last Name, First Name, Company Name. If there
is a Company Name the Last Name and First Name are null. I combine 3 fields
into 1 because it looks better that way: =[Refund].[First] & " " &
[Refund].[Last] & [Refund].[Company] AS Name.

In the past, I have 3 different queries to search for name: 1 for Last, 1
for First , and 1 for Company. Example: Like [Enter First Name: ]+"*" .

Now with name combined, I like to have 1 query only. User just need to enter
the name in the Parameter Value window, and access will search the name from
the
setting: =[Refund].[First] & " " & [Refund].[Last] & [Refund].[Company] AS
Name.

I failed. I think it is nice to be able to do so. Can we have a way to do
that.

Please help. Thanks much.
 
Well, as soon as I posted this question, I figured it out.
Just in case if any one curious, I put the like statement in the criteria:
Like [Enter Name: ] & '*'
It is the same way I used to do that. Have no idea!!!
 
Back
Top