C
CEV
I have a button on a form that opens a report based on a query. When I do
this, I get the error "You tried to execute a query that does not include
the specified expression 'Individuals.[Last Name]' as part of an aggregate
function."
SELECT Individuals.[Last Name], Individuals.[First Name], Individuals.SC,
Individuals.Supervisor, Individuals.Nurse, Individuals.[Social Security
Number], Individuals.[Middle Initial]
FROM Individuals
WHERE (((Individuals.[Last Name]) Like [Forms]![frmMonitoringRouting]![Last
Name]) AND ((Individuals.[First Name]) Like
[Forms]![frmMonitoringRouting]![First Name]));
On the report, i have a field with teh following: =[First Name] & " " &
[Middle Initial] & " " & [Last Name]
I do not understand where I went wrong.
Thanks,
CEV
this, I get the error "You tried to execute a query that does not include
the specified expression 'Individuals.[Last Name]' as part of an aggregate
function."
SELECT Individuals.[Last Name], Individuals.[First Name], Individuals.SC,
Individuals.Supervisor, Individuals.Nurse, Individuals.[Social Security
Number], Individuals.[Middle Initial]
FROM Individuals
WHERE (((Individuals.[Last Name]) Like [Forms]![frmMonitoringRouting]![Last
Name]) AND ((Individuals.[First Name]) Like
[Forms]![frmMonitoringRouting]![First Name]));
On the report, i have a field with teh following: =[First Name] & " " &
[Middle Initial] & " " & [Last Name]
I do not understand where I went wrong.
Thanks,
CEV