Report Grouping

[bryan87]

Hi All,

I am modifying the Personal Account Ledger template for Access 2007. I have
created a table for my accounts with the following fields.

ID - AutoNumber
Account - Text
Bank - Text

I have created a report to display the transactions grouped by account. The
problem is that report is displaying the ID field rather than the Account
field for each account group. Is there a way to have the account field be
displayed rather than the ID field?

I hope that made sense. I am still pretty new to access.

Thanks

 

[KARL DEWEY]

What you did not provide was an explaination of how the data gets from your
table to the display or was you are using for the display.

Do you have a query? Post the SQL.

Form? What is the source?

Report? What is the source?

 

[bryan87 via AccessMonster.com]

The source of the report is the "Accounts Transactions" table. Specifically
the "Account" field of the table which is a lookup with the following source
SELECT [Accounts].[ID], [Accounts].[Account] FROM Accounts;

I don't know if this is what you are asking for or not. If not, let me know.

Thanks

What you did not provide was an explaination of how the data gets from your
table to the display or was you are using for the display.

Do you have a query? Post the SQL.

Form? What is the source?

Report? What is the source?

Hi All,

[quoted text clipped - 15 lines]

.

 

[KARL DEWEY]

You have to join the Accounts table - something like this --
SELECT [Accounts].[Account], BANK
FROM [Accounts Transactions] INNER JOIN [Accounts] ON [Accounts
Transactions].[Account] = [Accounts].[ID]

You did not post all of the table and field names with datatype so I am
guessing.

--
Build a little, test a little.

The source of the report is the "Accounts Transactions" table. Specifically
the "Account" field of the table which is a lookup with the following source
SELECT [Accounts].[ID], [Accounts].[Account] FROM Accounts;

I don't know if this is what you are asking for or not. If not, let me know.

Thanks

What you did not provide was an explaination of how the data gets from your
table to the display or was you are using for the display.

Do you have a query? Post the SQL.

Form? What is the source?

Report? What is the source?

Hi All,

[quoted text clipped - 15 lines]

.

--



.

 

[bryan87 via AccessMonster.com]

My appologies, I thought I had list all of the fields for the table. Guess
not... Anyway, the following are the fields and data types for the "Account
Transactions" table.

ID - Autonumber
Entry Number - Number
Entry Date - Date/Time
Category - Number
Transaction Amount - Currency
Memo - Text
Account - Number

Thanks for the help.
Bryan

You have to join the Accounts table - something like this --
SELECT [Accounts].[Account], BANK
FROM [Accounts Transactions] INNER JOIN [Accounts] ON [Accounts
Transactions].[Account] = [Accounts].[ID]

You did not post all of the table and field names with datatype so I am
guessing.

The source of the report is the "Accounts Transactions" table. Specifically
the "Account" field of the table which is a lookup with the following source

[quoted text clipped - 18 lines]