Multiple Parameters

[jdwm2310]

Hello,

Is it possible to have more than one parameter in a query? If so, the query that I am working with will not generate the result for two criteria. When I remove one criteria the query will work by reporting the parameters result.

 

[mp9]

Please post the SQL from your query. Thanx.

http://www22.brinkster.com/accessory/

 

[jdwm2310]

here is the sql:
SELECT HelpDesk.CallerName, HelpDesk.CostCenter, BusinessUnit([CostCenter]) AS [Business Unit], HelpDesk.[Date Call], HelpDesk.Area, HelpDesk.UserName, HelpDesk.[Date Closed], HelpDesk.[Route To], HelpDesk.[Call Source], HelpDesk.TicketStatus
FROM HelpDesk
GROUP BY HelpDesk.CallerName, HelpDesk.CostCenter, HelpDesk.[Date Call], HelpDesk.Area, HelpDesk.UserName, HelpDesk.[Date Closed], HelpDesk.[Route To], HelpDesk.[Call Source], HelpDesk.TicketStatus, HelpDesk.TicketID, HelpDesk.EMPID, HelpDesk.JobTitle, HelpDesk.Telephone, HelpDesk.RequestedQuestion, HelpDesk.[Answer/Comments], HelpDesk.[Solved by], HelpDesk.TimeWorked2, HelpDesk.[Caller Status], HelpDesk.Lock, HelpDesk.[Starting Date], HelpDesk.CompanyName, GetElapsedTime([Date Closed]-[Date Call])
HAVING (((HelpDesk.CallerName) Is Not Null Or (HelpDesk.CallerName)="Select Name&quot AND ((BusinessUnit([CostCenter]))=[Enter Business Unit]) AND ((HelpDesk.[Date Call]) Between [Enter Date Starting] And [Enter Date Ending]));

which is not currently working, however when I remove the AND ((HelpDesk.[Date Call]) Between [Enter Date Starting] And [Enter Date Ending] it shows me the records based on the businessunit.
If I remove the ((BusinessUnit([CostCenter]))=[Enter Business Unit]) and leave the Date Call section then I would have the date range parameter.

Any ideas on how I can have both parameter?