Two Report Questions

[orgelizer via AccessMonster.com]

I have a file in Access 2003 which I use to keep track of my financial
transactions. Two of the tables are Chart of Accounts (two fields--account
number and account name) and Disbursement. I have a report which lists each
account number, along with the total amount spent in each account. I seem to
have forgotten how to have the account names show along with the account
number. I'm sure that one is simple, but it's slipped my mind.

Also, what sort of formatting instruction can I use so that I don't have the
account header and the detail split between pages when that happens? I
normally have six or seven account details per page, but the bottom of each
page has the account header for the account which shows up at the top of the
next page. I'd like to have everything kept together. And, speaking of keep
together, I do have that option selected for the header and the detail
section. How do I select both header and detail and have that kept together?

Enough redundant questions. Any assistance would be appreciated.

Thanks.

 

[Duane Hookom]

If you want a value from a field to appear in your report, the table
containing the field should be added to the report's record source.

You can set the "New Page" property to before or after sections.

 

[Marshall Barton]

I have a file in Access 2003 which I use to keep track of my financial
transactions. Two of the tables are Chart of Accounts (two fields--account
number and account name) and Disbursement. I have a report which lists each
account number, along with the total amount spent in each account. I seem to
have forgotten how to have the account names show along with the account
number. I'm sure that one is simple, but it's slipped my mind.

Also, what sort of formatting instruction can I use so that I don't have the
account header and the detail split between pages when that happens? I
normally have six or seven account details per page, but the bottom of each
page has the account header for the account which shows up at the top of the
next page. I'd like to have everything kept together. And, speaking of keep
together, I do have that option selected for the header and the detail
section. How do I select both header and detail and have that kept together?

To get the account name, you need to change the report
record source to a query that joins the two tables and
includes the account name field.

Set the account group (in Sorting and Grouping) KeepTogether
property to With First Detail