Suggestion about query

M

Michael Lam

I have using the wizard to create the following query and will generate a
report base on this query


SELECT DISTINCTROW RequestForm.[Approve Status], RequestForm.Department,
Format$([RequestForm].[Created Date],'Long Date') AS [Created Date/¤é],
Sum([RequestForm].[Estimate Effort]) AS [Á`­p ¤§ Estimate Effort], Count(*)
AS RequestForm¤§µ§¼Æ
FROM RequestForm
GROUP BY RequestForm.[Approve Status], RequestForm.Department,
Format$([RequestForm].[Created Date],'Long Date')
HAVING (((RequestForm.[Approve Status])="Accept"))
ORDER BY RequestForm.Department;

How can I modify this query so that the query able to select the record base
on the following criteria

[Approve status] = Accept or Reject based on the value from the form
[Create Date] between the date range enter in the form i.e (From
11-02-2004 to 11-02-2004)
[Department] (optional)

Do I just create the entry in the parameter like [Approve
Status]=[Forms]![NewForm]![combo32]

[Create Date] between [Forms]![NewForm]![FieldA]and
[Forms]![NewForm]![FieldB]

Please adviese
If not, Am I need to write two query in order to do this funciton?

THANKS
 
Top