SQL statement with 2 parameters

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

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

Thank you, that makes more sense than the way I had it!!

except that you cannot put WHERE after GROUP BY!!

furthermore, if you aren't going to use any aggregate functions, then you might as well drop the GROUP BY and use DISTINCT instead

rudy
http://r937.com/