Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
skiing - 20 May 2008 15:38 GMT
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 - 20 May 2008 15:53 GMT
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.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.