Working with report wzard

[newguy]

I am trying to make a simple report with a wizard, which is very
frustrating.

A few questions:

How can I add a field to the detail section of the report if I forgot
to select it with the wizard? The only way I know to do it is to
start over with the wizard.

How can I set up the report to ask for a parameter for a report? For
instance, which student to run a grade report for.

How can I get the report to give me a choice between running it for
all students and asking for a parameter?

Is there a good tutorial that addresses these sorts of questions?

Thanks

[pietlinden]

You add fields to a report the same way you add them to a form. Show
the Field List in design view and drop it in. you have to move/delete
the label that comes with it, but that's life.

Ask for a parameter... One way is to pass the parameter if you use the
DoCmd.OpenReport command... then you can just pass info through the
WHERE clause.

Read on www.mvps.org/access on filtering reports. There's one article
about including ALL in a combobox. You could use that and then just
use it to build your parameters before opening the report.

[New Guy]

On 12 Aug 2005 16:53:04 -0700, pi********@hotmail.com wrote:

You add fields to a report the same way you add them to a form. Show
the Field List in design view and drop it in. you have to move/delete
the label that comes with it, but that's life.

Ask for a parameter... One way is to pass the parameter if you use the
DoCmd.OpenReport command... then you can just pass info through the
WHERE clause.

Read on www.mvps.org/access on filtering reports. There's one article
about including ALL in a combobox. You could use that and then just
use it to build your parameters before opening the report.

The field list doesn't include the field I want because it wasn't
included from the original data source.

That's the problem. How can I get the additional field without
rerunning the wiazrd?

Thanks.

[mksnyder]

Save the report.
Close the report.
Add the columns to the table/query.
re-open the report.
Drop down the Field List.
Add the field as instructed.

New Guy wrote:

On 12 Aug 2005 16:53:04 -0700, pi********@hotmail.com wrote:

You add fields to a report the same way you add them to a form. Show
the Field List in design view and drop it in. you have to move/delete
the label that comes with it, but that's life.

Ask for a parameter... One way is to pass the parameter if you use the
DoCmd.OpenReport command... then you can just pass info through the
WHERE clause.

Read on www.mvps.org/access on filtering reports. There's one article
about including ALL in a combobox. You could use that and then just
use it to build your parameters before opening the report.

The field list doesn't include the field I want because it wasn't
included from the original data source.

That's the problem. How can I get the additional field without
rerunning the wiazrd?

Thanks.