Here's the query. (I forgot to post this last time)
SELECT
[Details].ID, [Details].Status,
([Details].Last_name & ', ' & [Details].First_name & ' '
& [Details].Middle_name) AS name,
[Details].County, [Details].Title,
[Details].Address_Mail & ' ' & [Details].suffix & IIf
([Details].U_type Is Null,'',' ' & [Details].u_type
& ' ' & [Details].unit) AS Address,
([Details].City_Mail & ', ' & [Details].state & '. ' &
[Details].Zip_Mail) AS LocatiOn,
Max(Pay.Type) AS Type, Count([Details].ID) AS cnt,
[Details].First_name, [Details].Last_name
FROM
([Details] Left Join [MAX] On [Details].ID = MAX.ID) Left
Join Pay On [Details].ID = Pay.ID
GROUP BY
[Details].ID, [Details].Status, ([Details].Last_name
& ', ' & [Details].First_name & ' ' &
[Details].Middle_name), [Details].County,
[Details].Title,
[Details].Address_Mail & ' ' & [Details].suffix & IIf
([Details].U_type Is Null,'',' ' & [Details].u_type
& ' ' & [Details].unit),
([Details].City_Mail & ', ' & [Details].state & '. ' &
[Details].Zip_Mail), [Details].First_name,
[Details].Last_name
HAVING
((([Details].First_name) Like Right(Trim([Forms]!
[Membership]![txtname]),Len(Trim([Forms]![Membership]!
[txtname]))-InStr(1,[Forms]![Membership]![txtname],","))
& '*') and
(([Details].Last_name) Like (Left([Forms]![Membership]!
[txtname],InStr(1,[Forms]![Membership]![txtname],",")-1))
& '*'))
ORDER BY
[Details].Status, ([Details].Last_name & ', ' &
[Details].First_name & ' ' & [Details].Middle_name)