Free Form Text Box in Report

[awalker]

Hi All,
I am running a report that runs from a Make Table Query, and then into a
cross tab query. The report is in a Switchboard and runs off of a Macro that
opens the make table, updates based off of the dates entered, closes it,
opens the cross tab. Closes it. Opens the report in print preview. I need
others to run the report with no intervention so I entered a text box (as I
have done before) into the header that reads: =[Enter Report Ending Date
mm/dd/yyy] to allow for the ending date to appear in the header. However,
this is not working. I am recieving the following error "The Microsoft Jet
database engine does not recognize "[Enter Report Ending Date mm/dd/yyy]" as
a valid field name or expression."

As I said, I've done this before and have had no problems, the only
difference is that the other report is not run off a make table/cross tab but
instead a seriers of regular queries. Thanks for any help you can provide.

 

[Duane Hookom]

If your report is based on a crosstab query then consider creating a new Row
Heading field expression like:
EndDate: [Enter Report Ending Date mm/dd/yyy]
Then add this to your crosstab query parameters:
[Enter Report Ending Date mm/dd/yyy] Date/Time

IMHO, you should read this value from a control on a form rather than a
parameter prompt.

 

[John Spencer]

First thing, with a crosstab query you MUST declare your parameters and if
any
other queries are used in the crosstab their parameters must also be
declared.

Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
Select the data type of the parameter in column 2

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..