G
Guest
How do I copy a calculated field from one report to another report? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Snell [MVP]
Maybe this question has a deeper complexity, but....
Open the report in design view. Click on the control. Press Ctrl+c. Open the
second report in design view. Click on the section where you want the
control to be placed. Press Ctrl+v.
Open the report in design view. Click on the control. Press Ctrl+c. Open the
second report in design view. Click on the section where you want the
control to be placed. Press Ctrl+v.
G
Guest
Sorry, I don't think I asked my question right. I have a report that has
several accounts and has a running total of each account. On my second
report I enter start date and end date, and it lists all the transaction for
that time period. I want the ending balance for each account to appear from
the previous table at the bottom of the 2nd report.
Example:
1st Report:
Account #: 2 Account Name: Sales Tax
Date Description Deposit Charge Balance
1/15/05 ??? 5.00 2.00 3.00
5/1/05 ??? 1.00 2.00
5/15/05 ??? 5.00 7.00
Account Total: 7.00
2nd Report
Account # 2 Account Name: Sales Tax
5/1/05 - 5/31/05 (brings up only data entered for this time period)
Date Description Deposit Charge Balance
5/1/05 ??? 1.00 (1.00)
5/15/05 ??? 5.00 5.00
Monthly Total: 4.00
Total from 1st report: Account Total: 7.00
I hope this makes sense. I appreciate any help you can give me. Thanks.
several accounts and has a running total of each account. On my second
report I enter start date and end date, and it lists all the transaction for
that time period. I want the ending balance for each account to appear from
the previous table at the bottom of the 2nd report.
Example:
1st Report:
Account #: 2 Account Name: Sales Tax
Date Description Deposit Charge Balance
1/15/05 ??? 5.00 2.00 3.00
5/1/05 ??? 1.00 2.00
5/15/05 ??? 5.00 7.00
Account Total: 7.00
2nd Report
Account # 2 Account Name: Sales Tax
5/1/05 - 5/31/05 (brings up only data entered for this time period)
Date Description Deposit Charge Balance
5/1/05 ??? 1.00 (1.00)
5/15/05 ??? 5.00 5.00
Monthly Total: 4.00
Total from 1st report: Account Total: 7.00
I hope this makes sense. I appreciate any help you can give me. Thanks.
K
Ken Snell [MVP]
Kinda thought that was too easy a question. < g >
On your second report, you're going to need to have a calculation that
"replicates" the calculation that is done on the first report. One report
cannot read data from another report, so you'll need to create a query that
will give you the records of the desired data, and then the calculated
control could use a DSum function with a criteria to filter and sum the
desired records.
--
Ken Snell
<MS ACCESS MVP>
On your second report, you're going to need to have a calculation that
"replicates" the calculation that is done on the first report. One report
cannot read data from another report, so you'll need to create a query that
will give you the records of the desired data, and then the calculated
control could use a DSum function with a criteria to filter and sum the
desired records.
--
Ken Snell
<MS ACCESS MVP>
G
Guest
I am not familar with DSum. My 1st report lists all enteries made from the
beginning to the end =Sum([Deposit]-[Charge]). And this will give me the
account balances. My 2nd report has a start and end date and will only show
the transactions done for that time period and also the balance for that
time. I need the 2nd report to show what the account balance is for each
account also; which, would need a field that calculates all the deposits and
charges from the beginning entry to the last entry. I do have a query that
lists all the transactions. I am not sure what my next step is. I am
probably confusing you. I know I am confused : )
beginning to the end =Sum([Deposit]-[Charge]). And this will give me the
account balances. My 2nd report has a start and end date and will only show
the transactions done for that time period and also the balance for that
time. I need the 2nd report to show what the account balance is for each
account also; which, would need a field that calculates all the deposits and
charges from the beginning entry to the last entry. I do have a query that
lists all the transactions. I am not sure what my next step is. I am
probably confusing you. I know I am confused : )
K
Ken Snell [MVP]
Post the recordsource of the first report. Also, provide the SQL statement
of the query that is that recordsource.
--
Ken Snell
<MS ACCESS MVP>
of the query that is that recordsource.
--
Ken Snell
<MS ACCESS MVP>
Sonya said:I am not familar with DSum. My 1st report lists all enteries made from the
beginning to the end =Sum([Deposit]-[Charge]). And this will give me the
account balances. My 2nd report has a start and end date and will only
show
the transactions done for that time period and also the balance for that
time. I need the 2nd report to show what the account balance is for each
account also; which, would need a field that calculates all the deposits
and
charges from the beginning entry to the last entry. I do have a query
that
lists all the transactions. I am not sure what my next step is. I am
probably confusing you. I know I am confused : )
Ken Snell said:Kinda thought that was too easy a question. < g >
On your second report, you're going to need to have a calculation that
"replicates" the calculation that is done on the first report. One report
cannot read data from another report, so you'll need to create a query
that
will give you the records of the desired data, and then the calculated
control could use a DSum function with a criteria to filter and sum the
desired records.
G
Guest
1st report recordsource is: Transaction Query
I feel like a complete idiot. I am a self taught Access person and have not
worked with creating SQL or codes myself. Any that are done Access has
created. So, I am not sure where to get the SQL statement of the query from.
I feel like a complete idiot. I am a self taught Access person and have not
worked with creating SQL or codes myself. Any that are done Access has
created. So, I am not sure where to get the SQL statement of the query from.
Ken Snell said:Post the recordsource of the first report. Also, provide the SQL statement
of the query that is that recordsource.
Ken Snell
<MS ACCESS MVP>
Sonya said:I am not familar with DSum. My 1st report lists all enteries made from the
beginning to the end =Sum([Deposit]-[Charge]). And this will give me the
account balances. My 2nd report has a start and end date and will only
show
the transactions done for that time period and also the balance for that
time. I need the 2nd report to show what the account balance is for each
account also; which, would need a field that calculates all the deposits
and
charges from the beginning entry to the last entry. I do have a query
that
lists all the transactions. I am not sure what my next step is. I am
probably confusing you. I know I am confused : )
Ken Snell said:Kinda thought that was too easy a question. < g >
On your second report, you're going to need to have a calculation that
"replicates" the calculation that is done on the first report. One report
cannot read data from another report, so you'll need to create a query
that
will give you the records of the desired data, and then the calculated
control could use a DSum function with a criteria to filter and sum the
desired records.
--
Ken Snell
<MS ACCESS MVP>
Sorry, I don't think I asked my question right. I have a report that
has
several accounts and has a running total of each account. On my
second
report I enter start date and end date, and it lists all the
transaction
for
that time period. I want the ending balance for each account to appear
from
the previous table at the bottom of the 2nd report.
Example:
1st Report:
Account #: 2 Account Name: Sales Tax
Date Description Deposit Charge Balance
1/15/05 ??? 5.00 2.00 3.00
5/1/05 ??? 1.00 2.00
5/15/05 ??? 5.00 7.00
Account Total: 7.00
2nd Report
Account # 2 Account Name: Sales Tax
5/1/05 - 5/31/05 (brings up only data entered for this time period)
Date Description Deposit Charge Balance
5/1/05 ??? 1.00
(1.00)
5/15/05 ??? 5.00 5.00
Monthly Total:
4.00
Total from 1st report: Account Total: 7.00
I hope this makes sense. I appreciate any help you can give me.
Thanks.
:
Maybe this question has a deeper complexity, but....
Open the report in design view. Click on the control. Press Ctrl+c.
Open
the
second report in design view. Click on the section where you want the
control to be placed. Press Ctrl+v.
--
Ken Snell
<MS ACCESS MVP>
How do I copy a calculated field from one report to another report?
Thanks.
K
Ken Snell [MVP]
Sonya said:1st report recordsource is: Transaction Query
I feel like a complete idiot. I am a self taught Access person and have
not
worked with creating SQL or codes myself. Any that are done Access has
created. So, I am not sure where to get the SQL statement of the query
from.
Open the query in design view. Click on View icon at far left of toolbar;
select SQL. Copy the entire statement that shows in that window and paste it
into your reply.
G
Guest
SELECT [Miscellaneous Info].[Transaction Date], [Miscellaneous
Accounts].[Account #], [Miscellaneous Info].[Voucher #], [Miscellaneous
Accounts].[Account Name], [Miscellaneous Info].Description, [Miscellaneous
Info].Deposit, [Miscellaneous Info].Charge, [Deposit]-[Charge] AS Expr1
FROM [Miscellaneous Accounts] INNER JOIN [Miscellaneous Info] ON
[Miscellaneous Accounts].[Account #] = [Miscellaneous Info].[Account #];
Accounts].[Account #], [Miscellaneous Info].[Voucher #], [Miscellaneous
Accounts].[Account Name], [Miscellaneous Info].Description, [Miscellaneous
Info].Deposit, [Miscellaneous Info].Charge, [Deposit]-[Charge] AS Expr1
FROM [Miscellaneous Accounts] INNER JOIN [Miscellaneous Info] ON
[Miscellaneous Accounts].[Account #] = [Miscellaneous Info].[Account #];
K
Ken Snell [MVP]
(copied SQL statement from your other post so that this thread is complete):
SELECT [Miscellaneous Info].[Transaction Date], [Miscellaneous
Accounts].[Account #], [Miscellaneous Info].[Voucher #], [Miscellaneous
Accounts].[Account Name], [Miscellaneous Info].Description, [Miscellaneous
Info].Deposit, [Miscellaneous Info].Charge, [Deposit]-[Charge] AS Expr1
FROM [Miscellaneous Accounts] INNER JOIN [Miscellaneous Info] ON
[Miscellaneous Accounts].[Account #] = [Miscellaneous Info].[Account #];
OK - the control source expression for the calculated control in the second
report would be something like this:
=DSum("Expr1", "Transaction Query", "[Miscellaneous Accounts].[Account #]="
& [NameOfAccountFieldInSecondReport])
The above assumes that Account # is numeric. If it's text:
=DSum("Expr1", "Transaction Query", "[Miscellaneous Accounts].[Account #]='"
& [NameOfAccountFieldInSecondReport] & "'")
--
Ken Snell
<MS ACCESS MVP>
SELECT [Miscellaneous Info].[Transaction Date], [Miscellaneous
Accounts].[Account #], [Miscellaneous Info].[Voucher #], [Miscellaneous
Accounts].[Account Name], [Miscellaneous Info].Description, [Miscellaneous
Info].Deposit, [Miscellaneous Info].Charge, [Deposit]-[Charge] AS Expr1
FROM [Miscellaneous Accounts] INNER JOIN [Miscellaneous Info] ON
[Miscellaneous Accounts].[Account #] = [Miscellaneous Info].[Account #];
OK - the control source expression for the calculated control in the second
report would be something like this:
=DSum("Expr1", "Transaction Query", "[Miscellaneous Accounts].[Account #]="
& [NameOfAccountFieldInSecondReport])
The above assumes that Account # is numeric. If it's text:
=DSum("Expr1", "Transaction Query", "[Miscellaneous Accounts].[Account #]='"
& [NameOfAccountFieldInSecondReport] & "'")
--
Ken Snell
<MS ACCESS MVP>
Sonya said:1st report recordsource is: Transaction Query
I feel like a complete idiot. I am a self taught Access person and have
not
worked with creating SQL or codes myself. Any that are done Access has
created. So, I am not sure where to get the SQL statement of the query
from.
Ken Snell said:Post the recordsource of the first report. Also, provide the SQL
statement
of the query that is that recordsource.Ken Snell
<MS ACCESS MVP>
Sonya said:I am not familar with DSum. My 1st report lists all enteries made from
the
beginning to the end =Sum([Deposit]-[Charge]). And this will give me
the
account balances. My 2nd report has a start and end date and will only
show
the transactions done for that time period and also the balance for
that
time. I need the 2nd report to show what the account balance is for
each
account also; which, would need a field that calculates all the
deposits
and
charges from the beginning entry to the last entry. I do have a query
that
lists all the transactions. I am not sure what my next step is. I am
probably confusing you. I know I am confused : )
:
Kinda thought that was too easy a question. < g >
On your second report, you're going to need to have a calculation that
"replicates" the calculation that is done on the first report. One
report
cannot read data from another report, so you'll need to create a query
that
will give you the records of the desired data, and then the calculated
control could use a DSum function with a criteria to filter and sum
the
desired records.
--
Ken Snell
<MS ACCESS MVP>
Sorry, I don't think I asked my question right. I have a report
that
has
several accounts and has a running total of each account. On my
second
report I enter start date and end date, and it lists all the
transaction
for
that time period. I want the ending balance for each account to
appear
from
the previous table at the bottom of the 2nd report.
Example:
1st Report:
Account #: 2 Account Name: Sales Tax
Date Description Deposit Charge Balance
1/15/05 ??? 5.00 2.00 3.00
5/1/05 ??? 1.00
2.00
5/15/05 ??? 5.00
7.00
Account Total:
7.00
2nd Report
Account # 2 Account Name: Sales Tax
5/1/05 - 5/31/05 (brings up only data entered for this time period)
Date Description Deposit Charge Balance
5/1/05 ??? 1.00
(1.00)
5/15/05 ??? 5.00
5.00
Monthly Total:
4.00
Total from 1st report: Account Total: 7.00
I hope this makes sense. I appreciate any help you can give me.
Thanks.
:
Maybe this question has a deeper complexity, but....
Open the report in design view. Click on the control. Press Ctrl+c.
Open
the
second report in design view. Click on the section where you want
the
control to be placed. Press Ctrl+v.
--
Ken Snell
<MS ACCESS MVP>
How do I copy a calculated field from one report to another
report?
Thanks.
G
Guest
I copied the formula and changed the [NameOfAccountFieldInSecondReport] to
the name that I want to use for the field in the 2nd report [AccountTotal]
and when I view it I get #Error. My Account # is numeric so I used the first
formula. I really appreciate your help.
the name that I want to use for the field in the 2nd report [AccountTotal]
and when I view it I get #Error. My Account # is numeric so I used the first
formula. I really appreciate your help.
Ken Snell said:(copied SQL statement from your other post so that this thread is complete):
SELECT [Miscellaneous Info].[Transaction Date], [Miscellaneous
Accounts].[Account #], [Miscellaneous Info].[Voucher #], [Miscellaneous
Accounts].[Account Name], [Miscellaneous Info].Description, [Miscellaneous
Info].Deposit, [Miscellaneous Info].Charge, [Deposit]-[Charge] AS Expr1
FROM [Miscellaneous Accounts] INNER JOIN [Miscellaneous Info] ON
[Miscellaneous Accounts].[Account #] = [Miscellaneous Info].[Account #];
OK - the control source expression for the calculated control in the second
report would be something like this:
=DSum("Expr1", "Transaction Query", "[Miscellaneous Accounts].[Account #]="
& [NameOfAccountFieldInSecondReport])
The above assumes that Account # is numeric. If it's text:
=DSum("Expr1", "Transaction Query", "[Miscellaneous Accounts].[Account #]='"
& [NameOfAccountFieldInSecondReport] & "'")
--
Ken Snell
<MS ACCESS MVP>
Sonya said:1st report recordsource is: Transaction Query
I feel like a complete idiot. I am a self taught Access person and have
not
worked with creating SQL or codes myself. Any that are done Access has
created. So, I am not sure where to get the SQL statement of the query
from.
Ken Snell said:Post the recordsource of the first report. Also, provide the SQL
statement
of the query that is that recordsource.Ken Snell
<MS ACCESS MVP>
I am not familar with DSum. My 1st report lists all enteries made from
the
beginning to the end =Sum([Deposit]-[Charge]). And this will give me
the
account balances. My 2nd report has a start and end date and will only
show
the transactions done for that time period and also the balance for
that
time. I need the 2nd report to show what the account balance is for
each
account also; which, would need a field that calculates all the
deposits
and
charges from the beginning entry to the last entry. I do have a query
that
lists all the transactions. I am not sure what my next step is. I am
probably confusing you. I know I am confused : )
:
Kinda thought that was too easy a question. < g >
On your second report, you're going to need to have a calculation that
"replicates" the calculation that is done on the first report. One
report
cannot read data from another report, so you'll need to create a query
that
will give you the records of the desired data, and then the calculated
control could use a DSum function with a criteria to filter and sum
the
desired records.
--
Ken Snell
<MS ACCESS MVP>
Sorry, I don't think I asked my question right. I have a report
that
has
several accounts and has a running total of each account. On my
second
report I enter start date and end date, and it lists all the
transaction
for
that time period. I want the ending balance for each account to
appear
from
the previous table at the bottom of the 2nd report.
Example:
1st Report:
Account #: 2 Account Name: Sales Tax
Date Description Deposit Charge Balance
1/15/05 ??? 5.00 2.00 3.00
5/1/05 ??? 1.00
2.00
5/15/05 ??? 5.00
7.00
Account Total:
7.00
2nd Report
Account # 2 Account Name: Sales Tax
5/1/05 - 5/31/05 (brings up only data entered for this time period)
Date Description Deposit Charge Balance
5/1/05 ??? 1.00
(1.00)
5/15/05 ??? 5.00
5.00
Monthly Total:
4.00
Total from 1st report: Account Total: 7.00
I hope this makes sense. I appreciate any help you can give me.
Thanks.
:
Maybe this question has a deeper complexity, but....
Open the report in design view. Click on the control. Press Ctrl+c.
Open
the
second report in design view. Click on the section where you want
the
control to be placed. Press Ctrl+v.
--
Ken Snell
<MS ACCESS MVP>
How do I copy a calculated field from one report to another
report?
Thanks.
K
Ken Snell [MVP]
Just to verify, you changed NameOfAccountFieldInSecondReport to the name of
the textbox that holds the account number on the second report? Is that
textbox bound to the field in the report's recordsource query that holds the
account number?
--
Ken Snell
<MS ACCESS MVP>
the textbox that holds the account number on the second report? Is that
textbox bound to the field in the report's recordsource query that holds the
account number?
--
Ken Snell
<MS ACCESS MVP>
Sonya said:I copied the formula and changed the [NameOfAccountFieldInSecondReport] to
the name that I want to use for the field in the 2nd report [AccountTotal]
and when I view it I get #Error. My Account # is numeric so I used the
first
formula. I really appreciate your help.
Ken Snell said:(copied SQL statement from your other post so that this thread is
complete):
SELECT [Miscellaneous Info].[Transaction Date], [Miscellaneous
Accounts].[Account #], [Miscellaneous Info].[Voucher #], [Miscellaneous
Accounts].[Account Name], [Miscellaneous Info].Description,
[Miscellaneous
Info].Deposit, [Miscellaneous Info].Charge, [Deposit]-[Charge] AS Expr1
FROM [Miscellaneous Accounts] INNER JOIN [Miscellaneous Info] ON
[Miscellaneous Accounts].[Account #] = [Miscellaneous Info].[Account #];
OK - the control source expression for the calculated control in the
second
report would be something like this:
=DSum("Expr1", "Transaction Query", "[Miscellaneous Accounts].[Account
#]="
& [NameOfAccountFieldInSecondReport])
The above assumes that Account # is numeric. If it's text:
=DSum("Expr1", "Transaction Query", "[Miscellaneous Accounts].[Account
#]='"
& [NameOfAccountFieldInSecondReport] & "'")
--
Ken Snell
<MS ACCESS MVP>
Sonya said:1st report recordsource is: Transaction Query
I feel like a complete idiot. I am a self taught Access person and
have
not
worked with creating SQL or codes myself. Any that are done Access has
created. So, I am not sure where to get the SQL statement of the query
from.
:
Post the recordsource of the first report. Also, provide the SQL
statement
of the query that is that recordsource.
Ken Snell
<MS ACCESS MVP>
I am not familar with DSum. My 1st report lists all enteries made
from
the
beginning to the end =Sum([Deposit]-[Charge]). And this will give
me
the
account balances. My 2nd report has a start and end date and will
only
show
the transactions done for that time period and also the balance for
that
time. I need the 2nd report to show what the account balance is for
each
account also; which, would need a field that calculates all the
deposits
and
charges from the beginning entry to the last entry. I do have a
query
that
lists all the transactions. I am not sure what my next step is. I
am
probably confusing you. I know I am confused : )
:
Kinda thought that was too easy a question. < g >
On your second report, you're going to need to have a calculation
that
"replicates" the calculation that is done on the first report. One
report
cannot read data from another report, so you'll need to create a
query
that
will give you the records of the desired data, and then the
calculated
control could use a DSum function with a criteria to filter and sum
the
desired records.
--
Ken Snell
<MS ACCESS MVP>
Sorry, I don't think I asked my question right. I have a report
that
has
several accounts and has a running total of each account. On my
second
report I enter start date and end date, and it lists all the
transaction
for
that time period. I want the ending balance for each account to
appear
from
the previous table at the bottom of the 2nd report.
Example:
1st Report:
Account #: 2 Account Name: Sales Tax
Date Description Deposit Charge Balance
1/15/05 ??? 5.00 2.00
3.00
5/1/05 ??? 1.00
2.00
5/15/05 ??? 5.00
7.00
Account Total:
7.00
2nd Report
Account # 2 Account Name: Sales Tax
5/1/05 - 5/31/05 (brings up only data entered for this time
period)
Date Description Deposit Charge Balance
5/1/05 ??? 1.00
(1.00)
5/15/05 ??? 5.00
5.00
Monthly Total:
4.00
Total from 1st report: Account Total: 7.00
I hope this makes sense. I appreciate any help you can give me.
Thanks.
:
Maybe this question has a deeper complexity, but....
Open the report in design view. Click on the control. Press
Ctrl+c.
Open
the
second report in design view. Click on the section where you
want
the
control to be placed. Press Ctrl+v.
--
Ken Snell
<MS ACCESS MVP>
How do I copy a calculated field from one report to another
report?
Thanks.
G
Guest
No, I wasn't using the Account #. I changed the field to that and it WORKS.
Thank you so very much. I really appreicate all the time you gave to this.
Thanks again...
Thank you so very much. I really appreicate all the time you gave to this.
Thanks again...
Ken Snell said:Just to verify, you changed NameOfAccountFieldInSecondReport to the name of
the textbox that holds the account number on the second report? Is that
textbox bound to the field in the report's recordsource query that holds the
account number?
--
Ken Snell
<MS ACCESS MVP>
Sonya said:I copied the formula and changed the [NameOfAccountFieldInSecondReport] to
the name that I want to use for the field in the 2nd report [AccountTotal]
and when I view it I get #Error. My Account # is numeric so I used the
first
formula. I really appreciate your help.
Ken Snell said:(copied SQL statement from your other post so that this thread is
complete):
SELECT [Miscellaneous Info].[Transaction Date], [Miscellaneous
Accounts].[Account #], [Miscellaneous Info].[Voucher #], [Miscellaneous
Accounts].[Account Name], [Miscellaneous Info].Description,
[Miscellaneous
Info].Deposit, [Miscellaneous Info].Charge, [Deposit]-[Charge] AS Expr1
FROM [Miscellaneous Accounts] INNER JOIN [Miscellaneous Info] ON
[Miscellaneous Accounts].[Account #] = [Miscellaneous Info].[Account #];
OK - the control source expression for the calculated control in the
second
report would be something like this:
=DSum("Expr1", "Transaction Query", "[Miscellaneous Accounts].[Account
#]="
& [NameOfAccountFieldInSecondReport])
The above assumes that Account # is numeric. If it's text:
=DSum("Expr1", "Transaction Query", "[Miscellaneous Accounts].[Account
#]='"
& [NameOfAccountFieldInSecondReport] & "'")
--
Ken Snell
<MS ACCESS MVP>
1st report recordsource is: Transaction Query
I feel like a complete idiot. I am a self taught Access person and
have
not
worked with creating SQL or codes myself. Any that are done Access has
created. So, I am not sure where to get the SQL statement of the query
from.
:
Post the recordsource of the first report. Also, provide the SQL
statement
of the query that is that recordsource.
Ken Snell
<MS ACCESS MVP>
I am not familar with DSum. My 1st report lists all enteries made
from
the
beginning to the end =Sum([Deposit]-[Charge]). And this will give
me
the
account balances. My 2nd report has a start and end date and will
only
show
the transactions done for that time period and also the balance for
that
time. I need the 2nd report to show what the account balance is for
each
account also; which, would need a field that calculates all the
deposits
and
charges from the beginning entry to the last entry. I do have a
query
that
lists all the transactions. I am not sure what my next step is. I
am
probably confusing you. I know I am confused : )
:
Kinda thought that was too easy a question. < g >
On your second report, you're going to need to have a calculation
that
"replicates" the calculation that is done on the first report. One
report
cannot read data from another report, so you'll need to create a
query
that
will give you the records of the desired data, and then the
calculated
control could use a DSum function with a criteria to filter and sum
the
desired records.
--
Ken Snell
<MS ACCESS MVP>
Sorry, I don't think I asked my question right. I have a report
that
has
several accounts and has a running total of each account. On my
second
report I enter start date and end date, and it lists all the
transaction
for
that time period. I want the ending balance for each account to
appear
from
the previous table at the bottom of the 2nd report.
Example:
1st Report:
Account #: 2 Account Name: Sales Tax
Date Description Deposit Charge Balance
1/15/05 ??? 5.00 2.00
3.00
5/1/05 ??? 1.00
2.00
5/15/05 ??? 5.00
7.00
Account Total:
7.00
2nd Report
Account # 2 Account Name: Sales Tax
5/1/05 - 5/31/05 (brings up only data entered for this time
period)
Date Description Deposit Charge Balance
5/1/05 ??? 1.00
(1.00)
5/15/05 ??? 5.00
5.00
Monthly Total:
4.00
Total from 1st report: Account Total: 7.00
I hope this makes sense. I appreciate any help you can give me.
Thanks.
:
Maybe this question has a deeper complexity, but....
Open the report in design view. Click on the control. Press
Ctrl+c.
Open
the
second report in design view. Click on the section where you
want
the
control to be placed. Press Ctrl+v.
--
Ken Snell
<MS ACCESS MVP>
How do I copy a calculated field from one report to another
report?
Thanks.