I'm making a query for a database and want to have 2 having parameters. this first one works but can't get the second one to.

SELECT Alum.LastName, Alum.FirstName, Alum.Street, Alum.City, Alum.State, Alum.Zipcode, Alum.Country, Alum.Phone, Alum.Email, Alum.Employer, Alum.Title, Alum.WhenGraduated, Alum.DateUpdated, Alum.InitiateNumber, Alum.CompName
FROM Alum
GROUP BY Alum.LastName, Alum.FirstName, Alum.Street, Alum.City, Alum.State, Alum.Zipcode, Alum.Country, Alum.Phone, Alum.Email, Alum.Employer, Alum.Title, Alum.WhenGraduated, Alum.DateUpdated, Alum.InitiateNumber, Alum.CompName
HAVING (((Alum.InitiateNumber)='::inum::'));

I would like to include Alum.FirstName='::fname::' in the having parameter but it keeps giving me an error. What I'm doing is having the two parameters query a database table and where the 2 equal what is entered, return the data from the record.

Any suggestions??!!
Thank you.

instead of using HAVING you should be using WHERE because you aren't using a group by clause. so it should look something like this

SELECT Alum.LastName, Alum.FirstName, Alum.Street, Alum.City, Alum.State, Alum.Zipcode, Alum.Country, Alum.Phone, Alum.Email, Alum.Employer, Alum.Title, Alum.WhenGraduated, Alum.DateUpdated, Alum.InitiateNumber, Alum.CompName
FROM Alum
GROUP BY Alum.LastName, Alum.FirstName, Alum.Street, Alum.City, Alum.State, Alum.Zipcode, Alum.Country, Alum.Phone, Alum.Email, Alum.Employer, Alum.Title, Alum.WhenGraduated, Alum.DateUpdated, Alum.InitiateNumber, Alum.CompName
WHERE Alum.InitiateNumber = 1;
the '1' is just the example number i used. if you want it related to a specific number you'll have to tell me what language you are using to display the data. hope that helps