Report Headers

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

Guest

I want to display the dates from a parameter query on a report without the
user being prompted twice to input the same values. Any way to do this?

I have already tried [enter begin date] & [enter ed date] on the report
header - that prompts the user twice - once from the underlying query and
once from the report header.

Any suggestions on avoiding that?

Thanks.
 
Make sure that you haven't made a slight difference in how you typed them
from one place to the other: a typo, an extra space, that sort of thing.
 
I want to display the dates from a parameter query on a report without the
user being prompted twice to input the same values. Any way to do this?

I have already tried [enter begin date] & [enter ed date] on the report
header - that prompts the user twice - once from the underlying query and
once from the report header.

Any suggestions on avoiding that?

Thanks.
Click to expand...

Make sure the spelling of the text within the brackets is identical to
the bracketed text in the query.
In your example above you wrote
[enter ed date] not [enter end date].
 
This is an exact copy of the underlying query - when I copy and paste this to
the control source on the text box for the report header I get a syntax
error???

Between [Enter Start Date: (mm/dd/yyyy)] And [Enter End Date: (mm/dd/yyyy)]

Douglas J. Steele said:
Make sure that you haven't made a slight difference in how you typed them
from one place to the other: a typo, an extra space, that sort of thing.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



C Markowitz said:
I want to display the dates from a parameter query on a report without the
user being prompted twice to input the same values. Any way to do this?

I have already tried [enter begin date] & [enter ed date] on the report
header - that prompts the user twice - once from the underlying query and
once from the report header.

Any suggestions on avoiding that?

Thanks.
Click to expand...
Click to expand...
 
Douglas said:
Make sure that you haven't made a slight difference in how you typed them
from one place to the other: a typo, an extra space, that sort of thing.
Click to expand...

I have a blunt hammer with which I can hoist in a solution in those
cases (where I should go find what's really wrong but I don't actually
care). Add a tiny table with only one record to your database; its
fields will be the values that you need to have as parameters. Fill the
table first, and add it to the source query for the report. You can now
apply filters by joining to this table.

Does that make sense?

Sometimes I do this to my settings table, too. I sometimes feel the need
to have pertaining values, much like public variables but less
susceptible to sudden death; I store those in one table. I have an
article on my site about that. It is easy to have a crosstab query on
this table, yielding exactly one record with all settings.

As a side remark.
 
C Markowitz said:
This is an exact copy of the underlying query - when I copy and paste this to
the control source on the text box for the report header I get a syntax
error???

Between [Enter Start Date: (mm/dd/yyyy)] And [Enter End Date:
Click to expand...
(mm/dd/yyyy)]

As a ControlSource you would have to enter...

="Between " & [Enter Start Date: (mm/dd/yyyy)] & " And " & [Enter End Date:
(mm/dd/yyyy)]
 
Thanks Rick - works great but all the text is bunched together - I swear by
the time I remember all the tricks in Access I will have thrown myself out a
window (lol). I appreciate your help!

Rick Brandt said:
C Markowitz said:
This is an exact copy of the underlying query - when I copy and paste this to
the control source on the text box for the report header I get a syntax
error???

Between [Enter Start Date: (mm/dd/yyyy)] And [Enter End Date:
Click to expand...
(mm/dd/yyyy)]

As a ControlSource you would have to enter...

="Between " & [Enter Start Date: (mm/dd/yyyy)] & " And " & [Enter End Date:
(mm/dd/yyyy)]
Click to expand...
 
C Markowitz said:
Thanks Rick - works great but all the text is bunched together - I swear by
the time I remember all the tricks in Access I will have thrown myself out a
window (lol). I appreciate your help!
Click to expand...

Did you include all of the spaces I had in my post?
 
Back
Top