Report Header

[Maggie]

Hello,

Right now I have a form that creates a report based on a
keyword that relates to a certain field in the table
(checkboxes) - essentially a query. However, I would
like the report to have a title page (in the report
header) section that identifies what field they searched
for, the keyword, and how many records were found. (I am
sure I can do the first 2, but I am having trouble
creating a report header - another form essentially) that
will count the number of records found and create a title
page to do this, any help would be appreciated. Thanks

Maggie

 

[Steve Schapel]

Maggie,

=Count(*)
.... as the controlsource of an unbound textbox in your report header
will show the number of records.
If you need any more help, please post back with some more details of
what you want to do.

- Steve Schapel, Microsoft Access MVP

 

[Maggie]

Steve,

Thanks, that works, but I have a few other questions - i
thought i could do myself.

In a form that calls this report, i have a textbox and a
number of checkboxes to indicate what field to search by
(and the textbox indicating a keyword for that field) -
how do show which checkbox they checked and the keyword

Thanks
Maggie

 

[Steve Schapel]

Maggie,

To refer to the keyword entered in the textbox...
=[Forms]![NameOfYourForm]![NameOfTextbox]

The checkbox thing is a bit trickier. I assume the situation is that
only one of the checkboxes should be selected at any given time. Am I
right? If so, it may be simpler to put the checkboxes into an Option
Group, and then make a little lookup table with 2 fields, OptionNumber
where you would enter the option value of each of the checkboxes, and
SearchField where you would enter the name of the field associated
with each checkbox. Then you could reference this table in the report
header to show the selected search field.

Having said all that, here is a comment, I hope you don't mind, that
goes beyond your question. What you are asking makes me highly
suspicious about the correctness of your table design. I may be
wrong, but I think your data structure is not adequately normalised.
If you are interested in exploring this aspect, please post back with
a bit more information about your data and the table fields that you
are searching on, and someone will be able to advise.

- Steve Schapel, Microsoft Access MVP