Report Header

[Alberta Rose]

I would like to include the parameters of my search in the report header. I
can get it to work when there is only a Page Header, Detail and Page Footer.
But when I add another detail such as a summary level, example: ="Dates
Between " & [REQUIRED FIELD: Select First Date] & "and" & [REQUIRED FIELD:
Select Last Date] that I have on my Report Header doesn't work. The message
box comes up twice to enter the date parameters and you have to enter the
dates twice or they won't show up on the Report Header.

Any suggestions?

 

[ryguy7272]

This is an Excel Programming discussion group. Nevertheless, a lot of us use
Access, and thus, may be able to offer some help. Check this out; found it
from an old Queries post over in the Access area...

#1) if you've declared the parameters as [Enter Start Date ] and then
referred to them as [Enter Start Date] (note the space at the end of the
first) then you will be prompted for both and only the referred value will
actually be used.

#2) You've applied a filter or sort to the query in datasheet view and saved
the change. This can sometimes cause the query to run twice. Once for the
acutual SQL and a second time to apply the filter or sort If this is the
case open the query in datasheet view and Select Remove Filter/Sort and save
the query.

In summary, you probably need to switch to SQL view, copy the SQL statement,
and paste it into a new query. Run the new query. IF you no longer get the
prompts and get the correct results, save the new version with the name of
the old version.


Good luck,
Ryan---

 

[Alberta Rose]

Thanks Ryan. It was instance #2 that was causing the grief. My appologies
for posting this on the wrong site, I've been doing so much work in Excel
lately that I wasn't paying enough attention I guess.

Thanks again....Laurie

This is an Excel Programming discussion group. Nevertheless, a lot of us use
Access, and thus, may be able to offer some help. Check this out; found it
from an old Queries post over in the Access area...

#1) if you've declared the parameters as [Enter Start Date ] and then
referred to them as [Enter Start Date] (note the space at the end of the
first) then you will be prompted for both and only the referred value will
actually be used.

#2) You've applied a filter or sort to the query in datasheet view and saved
the change. This can sometimes cause the query to run twice. Once for the
acutual SQL and a second time to apply the filter or sort If this is the
case open the query in datasheet view and Select Remove Filter/Sort and save
the query.

In summary, you probably need to switch to SQL view, copy the SQL statement,
and paste it into a new query. Run the new query. IF you no longer get the
prompts and get the correct results, save the new version with the name of
the old version.


Good luck,
Ryan---



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

I would like to include the parameters of my search in the report header. I
can get it to work when there is only a Page Header, Detail and Page Footer.
But when I add another detail such as a summary level, example: ="Dates
Between " & [REQUIRED FIELD: Select First Date] & "and" & [REQUIRED FIELD:
Select Last Date] that I have on my Report Header doesn't work. The message
box comes up twice to enter the date parameters and you have to enter the
dates twice or they won't show up on the Report Header.

Any suggestions?

 

[Alberta Rose]

Sorry about that, I had tried #2 and was only prompted once for the dates.
However, when I run the report, it doesn't filter out any dates and gives me
everything. I removed the filter from the query, as well I have copied the
SQL into a new query, with the same result.

Any ideas?

This is an Excel Programming discussion group. Nevertheless, a lot of us use
Access, and thus, may be able to offer some help. Check this out; found it
from an old Queries post over in the Access area...

#1) if you've declared the parameters as [Enter Start Date ] and then
referred to them as [Enter Start Date] (note the space at the end of the
first) then you will be prompted for both and only the referred value will
actually be used.

#2) You've applied a filter or sort to the query in datasheet view and saved
the change. This can sometimes cause the query to run twice. Once for the
acutual SQL and a second time to apply the filter or sort If this is the
case open the query in datasheet view and Select Remove Filter/Sort and save
the query.

In summary, you probably need to switch to SQL view, copy the SQL statement,
and paste it into a new query. Run the new query. IF you no longer get the
prompts and get the correct results, save the new version with the name of
the old version.


Good luck,
Ryan---



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

I would like to include the parameters of my search in the report header. I
can get it to work when there is only a Page Header, Detail and Page Footer.
But when I add another detail such as a summary level, example: ="Dates
Between " & [REQUIRED FIELD: Select First Date] & "and" & [REQUIRED FIELD:
Select Last Date] that I have on my Report Header doesn't work. The message
box comes up twice to enter the date parameters and you have to enter the
dates twice or they won't show up on the Report Header.

Any suggestions?