Try this --
SELECT [T-Package Table].[Package Type], Count([T-Drawing Table].[Drwg
No]) AS [CountOfDrwg No], Count([T-Package Table].[Package Number]) AS
[CountOfPackage Number], [T-Drawing Table].[Date Issued], [Enter Beginning
Issue Date], [enter ending issue date]
FROM [T-Package Table] INNER JOIN [T-Drawing Table] ON [T-Package
Table].[Package Number] = [T-Drawing Table].PackageNo
GROUP BY [T-Package Table].[Package Type], [T-Drawing Table].[Date
Issued], [Enter Beginning Issue Date], [enter ending issue date]
HAVING ((([T-Drawing Table].[Date Issued]) Between [Enter Beginning
Issue Date] And [enter ending issue date]));
This adds the prompts to the SELECT and GROUP BY sections of the SQL. They
must be identical - use copying and pasting.

Signature
KARL DEWEY
Build a little - Test a little
> Good morning
>
[quoted text clipped - 17 lines]
>
> thank you for any assistance anyone can offer !
skiing - 20 May 2008 16:04 GMT
> Try this --
> SELECT [T-Package Table].[Package Type], Count([T-Drawing Table].[Drwg
[quoted text clipped - 37 lines]
>
> - Show quoted text -
thank you for the assistance - can you advise as to pulling those
dates for the report display fields. I would only use them in a
header for the report which would state something like " Cycle Time:
BeginDate To EndDate " Where BeginDate and EndDate are the dates
which were entered at the query or report run state.
KARL DEWEY - 20 May 2008 19:21 GMT
Open the report in design view and click on menu VIEW - Field List and drag
into the header.

Signature
KARL DEWEY
Build a little - Test a little
> > Try this --
> > SELECT [T-Package Table].[Package Type], Count([T-Drawing Table].[Drwg
[quoted text clipped - 43 lines]
> BeginDate To EndDate " Where BeginDate and EndDate are the dates
> which were entered at the query or report run state.