Date Range Issues on Subreport

J

Joshua K Briley

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

Duane Hookom

Don't use parameter prompts for your criteria. Use controls on forms for
users to enter criteria values.
 
J

Joshua K Briley

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

Duane Hookom

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

Joshua K Briley

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