SELECT Statement in a Report

Does this make more sense? I'm looking forward to having closure on this... I
have to apply it to something else and we're looking to get this database
finished and start working on it.
Thanks.

"chickalina" wrote:

Maybe my note was cryptic?

I'll try again...

Page Header : Title of the report. Labels for Year 1, Year 2, etc.

CountryID Header: This is so the report sorts by Country, but the Country
name is in the Page header so it repeats at the top of the page in case there
is more than one page in each country.

Structural Header: This is the second sort level.

Details: Idea Description and the Totals for each idea by year.

Structural Footer: Totals by year for all the ideas in that country.

Page Footer: Page number and current date.


I am trying to do this in a report. Let me see if I have this correct:

1. I do not need the crosstab query I've created, I should use the tables
that store the information.

2. for the label name in the page header I should use for the 5 years: Year
1, Year 2, etc. and the actual years would appear when a start date is typed.
I should use the "Select" code in a text box "row source" forthe calculations
in the detail
section. The determining start date will be entered in a "pop up" form
before the report is open. This will also be code.

3. I would like to see at the bottom of each country a total by
[benefittype]: some ideas are cash, some are ETR and some are both. I need
these three line items at the bottom of the page per country. This can be
done with a select
statement, but in which section? This is what I don't get. I've tried the
code
in the details section, page header, page footer, you name it. It doesn't
work. I checked and rechecked the code.

So, if this is correct, what code should I be using?

I hope this is more clear then before and you can help.

Thanks for your help John, I appreciate it!
M