Report Headers

[C Markowitz]

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.

 

[Douglas J. Steele]

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.

 

[fredg]

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

 

[C Markowitz]

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)]

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!)

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.

 

[Bas Cost Budde]

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

 

[Rick Brandt]

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)]

As a ControlSource you would have to enter...

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

 

[C Markowitz]

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!

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)]

As a ControlSource you would have to enter...

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

 

[Rick Brandt]

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!

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