Parameter search

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

Guest

I need to search for the last name of client and last name of spouse, two
seperate fields. I'd like to be able to ask for the last name once and have
both fileds search and return those records. Is ts thjis possible?

Thanks

Jo
 
I need to search for the last name of client and last name of spouse, two
seperate fields. I'd like to be able to ask for the last name once and have
both fileds search and return those records. Is ts thjis possible?

Thanks

Jo
Click to expand...

As criteria on the Client LastName AND the Spouse LazstName columns,
write
[What Name?]

Write the above on the same criteria row, so that the Where clause is
an "AND" clause.
Only records where the entered name is the same for both Client and
Spouse will be returned.

If you want records that have the entered name in either the Client or
Spouse column (some spouses do have a different last name .. by
choice), write the criteria on 2 different rows. This will create an
"OR" where clause.
 
Thanks, this did the trick. Much appreciated

fredg said:
I need to search for the last name of client and last name of spouse, two
seperate fields. I'd like to be able to ask for the last name once and have
both fileds search and return those records. Is ts thjis possible?

Thanks

Jo
Click to expand...

As criteria on the Client LastName AND the Spouse LazstName columns,
write
[What Name?]

Write the above on the same criteria row, so that the Where clause is
an "AND" clause.
Only records where the entered name is the same for both Client and
Spouse will be returned.

If you want records that have the entered name in either the Client or
Spouse column (some spouses do have a different last name .. by
choice), write the criteria on 2 different rows. This will create an
"OR" where clause.
Click to expand...
 
Back
Top