Copy a calculated field from one report to another

How do I copy a calculated field from one report to another report? 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

"Sonya" wrote in message
...
How do I copy a calculated field from one report to another report?
Thanks.

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.



"Ken Snell [MVP]" wrote:

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

"Sonya" wrote in message
...
How do I copy a calculated field from one report to another report?
Thanks.

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


"Sonya" wrote in message
...
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.



"Ken Snell [MVP]" wrote:

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

"Sonya" wrote in message
...
How do I copy a calculated field from one report to another report?
Thanks.

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 [MVP]" wrote:

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


"Sonya" wrote in message
...
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.



"Ken Snell [MVP]" wrote:

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

"Sonya" wrote in message
...
How do I copy a calculated field from one report to another report?
Thanks.

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" wrote in message
...
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 [MVP]" wrote:

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


"Sonya" wrote in message
...
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.



"Ken Snell [MVP]" wrote:

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

"Sonya" wrote in message
...
How do I copy a calculated field from one report to another report?
Thanks.

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 [MVP]" wrote:

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" wrote in message
...
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 [MVP]" wrote:

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


"Sonya" wrote in message
...
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.



"Ken Snell [MVP]" wrote:

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

"Sonya" wrote in message
...
How do I copy a calculated field from one report to another report?
Thanks.

"Sonya" wrote in message
...
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.

--

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 #];


"Ken Snell [MVP]" wrote:

"Sonya" wrote in message
...
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.

--

Ken Snell
MS ACCESS 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


"Sonya" wrote in message
...
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 [MVP]" wrote:

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" wrote in message
...
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 [MVP]" wrote:

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


"Sonya" wrote in message
...
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.



"Ken Snell [MVP]" wrote:

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

"Sonya" wrote in message
...
How do I copy a calculated field from one report to another
report?
Thanks.