retain entry from parameter query (2 entries) for report display

[skiing]

Good morning

I have a query which prompts for Beginning Date and Ending Date on an
existing field. I would like to have the Beginning Date and Ending
Date print on a Report. Can I retain the value entered for Beginning
Date and Ending Date in a field to be used in the report? I am
unfamiliar with SQL but feel I would need to use the SQL of the query
to accomplish this task - if so, would still be unsure as to how to
retrieve the fields for the report. Below is the SQL for my query:

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]
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]
HAVING ((([T-Drawing Table].[Date Issued]) Between [Enter Beginning
Issue Date] And [enter ending issue date]));


thank you for any assistance anyone can offer !

 

[KARL DEWEY]

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.

 

[skiing]

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.
--
KARL DEWEY
Build a little - Test a little

Good morning

I have a query which prompts for Beginning Date and Ending Date on an
existing field.  I would like to have the Beginning Date and Ending
Date print on a Report.  Can I retain the value entered for Beginning
Date and Ending Date in a field to be used in the report?  I am
unfamiliar with SQL but feel I would need to use the SQL of the query
to accomplish this task - if so, would still be unsure as to how to
retrieve the fields for the report.  Below is the SQL for my query:

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]
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]
HAVING ((([T-Drawing Table].[Date Issued]) Between [Enter Beginning
Issue Date] And [enter ending issue date]));

thank you for any assistance anyone can offer !- Hide quoted text -

- 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]

Open the report in design view and click on menu VIEW - Field List and drag
into the header.
--
KARL DEWEY
Build a little - Test a little

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.
--
KARL DEWEY
Build a little - Test a little

Good morning

I have a query which prompts for Beginning Date and Ending Date on an
existing field. I would like to have the Beginning Date and Ending
Date print on a Report. Can I retain the value entered for Beginning
Date and Ending Date in a field to be used in the report? I am
unfamiliar with SQL but feel I would need to use the SQL of the query
to accomplish this task - if so, would still be unsure as to how to
retrieve the fields for the report. Below is the SQL for my query:

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]
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]
HAVING ((([T-Drawing Table].[Date Issued]) Between [Enter Beginning
Issue Date] And [enter ending issue date]));

thank you for any assistance anyone can offer !- Hide quoted text -

- 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.