Date Range Issues on Subreport

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have to queries, feeding two separate reports. One report is being used
as a sub report for the other:

Here are the queries:

SELECT Address.[EE#], Address.[Test Type], Address.[Area & Block],
Address.[Collected Date], Address.[O&G Result]
FROM Address
WHERE (((Address.[EE#]) Like "C*") AND ((Address.[Test Type]) Like "CP" Or
(Address.[Test Type]) Like "SH*" Or (Address.[Test Type]) Like "CPW") AND
((Address.[Collected Date])>=[Beginning Date] And (Address.[Collected
Date])<=[Ending Date]) AND ((Address.Company) Like "El Paso"))
ORDER BY Address.[Area & Block];

______________________________________________________________________________

SELECT Address.Company, Address.[EE#], Address.[Area & Block], Address.[Test
Type], Address.fictitiousCollectDate
FROM Address
WHERE (((Address.Company) Like "El Paso") AND ((Address.[EE#]) Like "C*")
AND ((Address.[Test Type]) Like "CWP") AND
((Address.fictitiousCollectDate)>=[Beginning Date] And
(Address.fictitiousCollectDate)<=[Ending Date]))
ORDER BY Address.[Area & Block];

The second query is used for the report being used as the subreport. I have
date parameters for [Collected Date] in the first query and the same for
[fictitiousCollectDate] in the second query. However, when I run the report,
I am being asked to enter the date range 4 times? Is there something I can
do to avoid the redundant date entries? Any help would be greatly
appreciated. Thank you.
 
Don't use parameter prompts for your criteria. Use controls on forms for
users to enter criteria values.
 
Sorry,

Not quite sure how to accomplish this. The report is being run from a
query. Can you offer any advice on how to accomplish your recommendation?
--
Somecallmejosh


Duane Hookom said:
Don't use parameter prompts for your criteria. Use controls on forms for
users to enter criteria values.

--
Duane Hookom
MS Access MVP
--

Joshua K Briley said:
Hello,

I have to queries, feeding two separate reports. One report is being used
as a sub report for the other:

Here are the queries:

SELECT Address.[EE#], Address.[Test Type], Address.[Area & Block],
Address.[Collected Date], Address.[O&G Result]
FROM Address
WHERE (((Address.[EE#]) Like "C*") AND ((Address.[Test Type]) Like "CP" Or
(Address.[Test Type]) Like "SH*" Or (Address.[Test Type]) Like "CPW") AND
((Address.[Collected Date])>=[Beginning Date] And (Address.[Collected
Date])<=[Ending Date]) AND ((Address.Company) Like "El Paso"))
ORDER BY Address.[Area & Block];

______________________________________________________________________________

SELECT Address.Company, Address.[EE#], Address.[Area & Block],
Address.[Test
Type], Address.fictitiousCollectDate
FROM Address
WHERE (((Address.Company) Like "El Paso") AND ((Address.[EE#]) Like "C*")
AND ((Address.[Test Type]) Like "CWP") AND
((Address.fictitiousCollectDate)>=[Beginning Date] And
(Address.fictitiousCollectDate)<=[Ending Date]))
ORDER BY Address.[Area & Block];

The second query is used for the report being used as the subreport. I
have
date parameters for [Collected Date] in the first query and the same for
[fictitiousCollectDate] in the second query. However, when I run the
report,
I am being asked to enter the date range 4 times? Is there something I
can
do to avoid the redundant date entries? Any help would be greatly
appreciated. Thank you.
Click to expand...
Click to expand...
 
Check out http://www.fontstuff.com/access/acctut08.htm

--
Duane Hookom
MS Access MVP
--

Joshua K Briley said:
Sorry,

Not quite sure how to accomplish this. The report is being run from a
query. Can you offer any advice on how to accomplish your recommendation?
--
Somecallmejosh


Duane Hookom said:
Don't use parameter prompts for your criteria. Use controls on forms for
users to enter criteria values.

--
Duane Hookom
MS Access MVP
--

message
Hello,

I have to queries, feeding two separate reports. One report is being
used
as a sub report for the other:

Here are the queries:

SELECT Address.[EE#], Address.[Test Type], Address.[Area & Block],
Address.[Collected Date], Address.[O&G Result]
FROM Address
WHERE (((Address.[EE#]) Like "C*") AND ((Address.[Test Type]) Like "CP"
Or
(Address.[Test Type]) Like "SH*" Or (Address.[Test Type]) Like "CPW")
AND
((Address.[Collected Date])>=[Beginning Date] And (Address.[Collected
Date])<=[Ending Date]) AND ((Address.Company) Like "El Paso"))
ORDER BY Address.[Area & Block];

______________________________________________________________________________

SELECT Address.Company, Address.[EE#], Address.[Area & Block],
Address.[Test
Type], Address.fictitiousCollectDate
FROM Address
WHERE (((Address.Company) Like "El Paso") AND ((Address.[EE#]) Like
"C*")
AND ((Address.[Test Type]) Like "CWP") AND
((Address.fictitiousCollectDate)>=[Beginning Date] And
(Address.fictitiousCollectDate)<=[Ending Date]))
ORDER BY Address.[Area & Block];

The second query is used for the report being used as the subreport. I
have
date parameters for [Collected Date] in the first query and the same
for
[fictitiousCollectDate] in the second query. However, when I run the
report,
I am being asked to enter the date range 4 times? Is there something I
can
do to avoid the redundant date entries? Any help would be greatly
appreciated. Thank you.
Click to expand...
Click to expand...
Click to expand...
 
This is great material. Thank you very much.
--
Somecallmejosh


Duane Hookom said:
Check out http://www.fontstuff.com/access/acctut08.htm

--
Duane Hookom
MS Access MVP
--

Joshua K Briley said:
Sorry,

Not quite sure how to accomplish this. The report is being run from a
query. Can you offer any advice on how to accomplish your recommendation?
--
Somecallmejosh


Duane Hookom said:
Don't use parameter prompts for your criteria. Use controls on forms for
users to enter criteria values.

--
Duane Hookom
MS Access MVP
--

message
Hello,

I have to queries, feeding two separate reports. One report is being
used
as a sub report for the other:

Here are the queries:

SELECT Address.[EE#], Address.[Test Type], Address.[Area & Block],
Address.[Collected Date], Address.[O&G Result]
FROM Address
WHERE (((Address.[EE#]) Like "C*") AND ((Address.[Test Type]) Like "CP"
Or
(Address.[Test Type]) Like "SH*" Or (Address.[Test Type]) Like "CPW")
AND
((Address.[Collected Date])>=[Beginning Date] And (Address.[Collected
Date])<=[Ending Date]) AND ((Address.Company) Like "El Paso"))
ORDER BY Address.[Area & Block];

______________________________________________________________________________

SELECT Address.Company, Address.[EE#], Address.[Area & Block],
Address.[Test
Type], Address.fictitiousCollectDate
FROM Address
WHERE (((Address.Company) Like "El Paso") AND ((Address.[EE#]) Like
"C*")
AND ((Address.[Test Type]) Like "CWP") AND
((Address.fictitiousCollectDate)>=[Beginning Date] And
(Address.fictitiousCollectDate)<=[Ending Date]))
ORDER BY Address.[Area & Block];

The second query is used for the report being used as the subreport. I
have
date parameters for [Collected Date] in the first query and the same
for
[fictitiousCollectDate] in the second query. However, when I run the
report,
I am being asked to enter the date range 4 times? Is there something I
can
do to avoid the redundant date entries? Any help would be greatly
appreciated. Thank you.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top