Create a balance on every line of a report

[Pedro]

Hi everyone
I'm looking for days an answer for my problem. I'd like to create a balance
on my report. Excel does it perfectly but, naturaly, access is better to do
it, but how?
My Qry has number_mov (sequencial), date_mov, Descr_mov, Value_mov, and i'm
doing it on a report, so i 'd like to add a balance but i'm kinda stuck here.
Can you help me please?
Tks a lot
Pedro

 

[golfinray]

There is a running sum property in you report properties. Then to get a
total, drag down the report footer and put a textbox on it. Make the control
source of the textbox =sum([your field])

 

[Pedro]

"There is a running sum property in you report properties". I'm so sorry, can
you be more specific?
About making control source ...i've copy a control box of the footer that
were summing and put it on the detail section, like i want it, but no good
result. Can you help me on this one?
Tks very much for your help.
Best regards
Pedro

There is a running sum property in you report properties. Then to get a
total, drag down the report footer and put a textbox on it. Make the control
source of the textbox =sum([your field])

Hi everyone
I'm looking for days an answer for my problem. I'd like to create a balance
on my report. Excel does it perfectly but, naturaly, access is better to do
it, but how?
My Qry has number_mov (sequencial), date_mov, Descr_mov, Value_mov, and i'm
doing it on a report, so i 'd like to add a balance but i'm kinda stuck here.
Can you help me please?
Tks a lot
Pedro

 

[Pedro]

There is a running sum property in you report properties. Then to get a
total, drag down the report footer and put a textbox on it. Make the control
source of the textbox =sum([your field])

Hi everyone
I'm looking for days an answer for my problem. I'd like to create a balance
on my report. Excel does it perfectly but, naturaly, access is better to do
it, but how?
My Qry has number_mov (sequencial), date_mov, Descr_mov, Value_mov, and i'm
doing it on a report, so i 'd like to add a balance but i'm kinda stuck here.
Can you help me please?
Tks a lot
Pedro

 

[Gina Whipp]

Pedro,

The running sum property is in the control. Go to Properties of the control
and once there search your choices. You will see one that is Running Sum
change that to Yes.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"There is a running sum property in you report properties". I'm so sorry,
can
you be more specific?
About making control source ...i've copy a control box of the footer that
were summing and put it on the detail section, like i want it, but no good
result. Can you help me on this one?
Tks very much for your help.
Best regards
Pedro

There is a running sum property in you report properties. Then to get a
total, drag down the report footer and put a textbox on it. Make the
control
source of the textbox =sum([your field])

Hi everyone
I'm looking for days an answer for my problem. I'd like to create a
balance
on my report. Excel does it perfectly but, naturaly, access is better
to do
it, but how?
My Qry has number_mov (sequencial), date_mov, Descr_mov, Value_mov, and
i'm
doing it on a report, so i 'd like to add a balance but i'm kinda stuck
here.
Can you help me please?
Tks a lot
Pedro

 

[Pedro]

Gina
Many thanks for your help. It's done but ... supose the total of this report
is 50. This new control shows in the first line 50, and on the 2nd, 100, on
the 3rd, 150 and so on ...
Can you help me again?
Many thanks
Pedro

Pedro,

The running sum property is in the control. Go to Properties of the control
and once there search your choices. You will see one that is Running Sum
change that to Yes.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"There is a running sum property in you report properties". I'm so sorry,
can
you be more specific?
About making control source ...i've copy a control box of the footer that
were summing and put it on the detail section, like i want it, but no good
result. Can you help me on this one?
Tks very much for your help.
Best regards
Pedro

There is a running sum property in you report properties. Then to get a
total, drag down the report footer and put a textbox on it. Make the
control
source of the textbox =sum([your field])

:

Hi everyone
I'm looking for days an answer for my problem. I'd like to create a
balance
on my report. Excel does it perfectly but, naturaly, access is better
to do
it, but how?
My Qry has number_mov (sequencial), date_mov, Descr_mov, Value_mov, and
i'm
doing it on a report, so i 'd like to add a balance but i'm kinda stuck
here.
Can you help me please?
Tks a lot
Pedro

 

[Gina Whipp]

Pedro,

Is this control in the report footer?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina
Many thanks for your help. It's done but ... supose the total of this
report
is 50. This new control shows in the first line 50, and on the 2nd, 100,
on
the 3rd, 150 and so on ...
Can you help me again?
Many thanks
Pedro

Pedro,

The running sum property is in the control. Go to Properties of the
control
and once there search your choices. You will see one that is Running Sum
change that to Yes.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"There is a running sum property in you report properties". I'm so
sorry,
can
you be more specific?
About making control source ...i've copy a control box of the footer
that
were summing and put it on the detail section, like i want it, but no
good
result. Can you help me on this one?
Tks very much for your help.
Best regards
Pedro

:

There is a running sum property in you report properties. Then to get
a
total, drag down the report footer and put a textbox on it. Make the
control
source of the textbox =sum([your field])

:

Hi everyone
I'm looking for days an answer for my problem. I'd like to create a
balance
on my report. Excel does it perfectly but, naturaly, access is
better
to do
it, but how?
My Qry has number_mov (sequencial), date_mov, Descr_mov, Value_mov,
and
i'm
doing it on a report, so i 'd like to add a balance but i'm kinda
stuck
here.
Can you help me please?
Tks a lot
Pedro

 

[Pedro]

Hi Gina
No, this control is in the detail section. I've copy and past it from the
footer section but i've also done a new one. Same result for both control.
Kinda weird, no?
Many thanks for your help
Pedro

Pedro,

Is this control in the report footer?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina
Many thanks for your help. It's done but ... supose the total of this
report
is 50. This new control shows in the first line 50, and on the 2nd, 100,
on
the 3rd, 150 and so on ...
Can you help me again?
Many thanks
Pedro

Pedro,

The running sum property is in the control. Go to Properties of the
control
and once there search your choices. You will see one that is Running Sum
change that to Yes.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"There is a running sum property in you report properties". I'm so
sorry,
can
you be more specific?
About making control source ...i've copy a control box of the footer
that
were summing and put it on the detail section, like i want it, but no
good
result. Can you help me on this one?
Tks very much for your help.
Best regards
Pedro

:

There is a running sum property in you report properties. Then to get
a
total, drag down the report footer and put a textbox on it. Make the
control
source of the textbox =sum([your field])

:

Hi everyone
I'm looking for days an answer for my problem. I'd like to create a
balance
on my report. Excel does it perfectly but, naturaly, access is
better
to do
it, but how?
My Qry has number_mov (sequencial), date_mov, Descr_mov, Value_mov,
and
i'm
doing it on a report, so i 'd like to add a balance but i'm kinda
stuck
here.
Can you help me please?
Tks a lot
Pedro

 

[Gina Whipp]

Pedro,

Yes, that is wierd... Exactly what do you have entered in this control?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina
No, this control is in the detail section. I've copy and past it from the
footer section but i've also done a new one. Same result for both control.
Kinda weird, no?
Many thanks for your help
Pedro

Pedro,

Is this control in the report footer?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina
Many thanks for your help. It's done but ... supose the total of this
report
is 50. This new control shows in the first line 50, and on the 2nd,
100,
on
the 3rd, 150 and so on ...
Can you help me again?
Many thanks
Pedro


:

Pedro,

The running sum property is in the control. Go to Properties of the
control
and once there search your choices. You will see one that is Running
Sum
change that to Yes.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"There is a running sum property in you report properties". I'm so
sorry,
can
you be more specific?
About making control source ...i've copy a control box of the footer
that
were summing and put it on the detail section, like i want it, but
no
good
result. Can you help me on this one?
Tks very much for your help.
Best regards
Pedro

:

There is a running sum property in you report properties. Then to
get
a
total, drag down the report footer and put a textbox on it. Make
the
control
source of the textbox =sum([your field])

:

Hi everyone
I'm looking for days an answer for my problem. I'd like to create
a
balance
on my report. Excel does it perfectly but, naturaly, access is
better
to do
it, but how?
My Qry has number_mov (sequencial), date_mov, Descr_mov,
Value_mov,
and
i'm
doing it on a report, so i 'd like to add a balance but i'm kinda
stuck
here.
Can you help me please?
Tks a lot
Pedro

 

[Pedro]

Hope this helps

Saldo CCC
=Soma([Valor Movimento])
Padrão
2

Sim
Não
Não
Não
Não
Total
14,683cm
0,688cm
....

Pedro,

Yes, that is wierd... Exactly what do you have entered in this control?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina
No, this control is in the detail section. I've copy and past it from the
footer section but i've also done a new one. Same result for both control.
Kinda weird, no?
Many thanks for your help
Pedro

Pedro,

Is this control in the report footer?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina
Many thanks for your help. It's done but ... supose the total of this
report
is 50. This new control shows in the first line 50, and on the 2nd,
100,
on
the 3rd, 150 and so on ...
Can you help me again?
Many thanks
Pedro


:

Pedro,

The running sum property is in the control. Go to Properties of the
control
and once there search your choices. You will see one that is Running
Sum
change that to Yes.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"There is a running sum property in you report properties". I'm so
sorry,
can
you be more specific?
About making control source ...i've copy a control box of the footer
that
were summing and put it on the detail section, like i want it, but
no
good
result. Can you help me on this one?
Tks very much for your help.
Best regards
Pedro

:

There is a running sum property in you report properties. Then to
get
a
total, drag down the report footer and put a textbox on it. Make
the
control
source of the textbox =sum([your field])

:

Hi everyone
I'm looking for days an answer for my problem. I'd like to create
a
balance
on my report. Excel does it perfectly but, naturaly, access is
better
to do
it, but how?
My Qry has number_mov (sequencial), date_mov, Descr_mov,
Value_mov,
and
i'm
doing it on a report, so i 'd like to add a balance but i'm kinda
stuck
here.
Can you help me please?
Tks a lot
Pedro

 

[Gina Whipp]

Can you help me out with a trans;ation? And is this is the footer?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hope this helps

Saldo CCC
=Soma([Valor Movimento])
Padrão
2

Sim
Não
Não
Não
Não
Total
14,683cm
0,688cm
...

Pedro,

Yes, that is wierd... Exactly what do you have entered in this control?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina
No, this control is in the detail section. I've copy and past it from
the
footer section but i've also done a new one. Same result for both
control.
Kinda weird, no?
Many thanks for your help
Pedro

:

Pedro,

Is this control in the report footer?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina
Many thanks for your help. It's done but ... supose the total of
this
report
is 50. This new control shows in the first line 50, and on the 2nd,
100,
on
the 3rd, 150 and so on ...
Can you help me again?
Many thanks
Pedro


:

Pedro,

The running sum property is in the control. Go to Properties of
the
control
and once there search your choices. You will see one that is
Running
Sum
change that to Yes.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"There is a running sum property in you report properties". I'm
so
sorry,
can
you be more specific?
About making control source ...i've copy a control box of the
footer
that
were summing and put it on the detail section, like i want it,
but
no
good
result. Can you help me on this one?
Tks very much for your help.
Best regards
Pedro

:

There is a running sum property in you report properties. Then
to
get
a
total, drag down the report footer and put a textbox on it. Make
the
control
source of the textbox =sum([your field])

:

Hi everyone
I'm looking for days an answer for my problem. I'd like to
create
a
balance
on my report. Excel does it perfectly but, naturaly, access is
better
to do
it, but how?
My Qry has number_mov (sequencial), date_mov, Descr_mov,
Value_mov,
and
i'm
doing it on a report, so i 'd like to add a balance but i'm
kinda
stuck
here.
Can you help me please?
Tks a lot
Pedro

 

[Pedro]

Sure. Please see below. This control is in the detail section.

Can you help me out with a trans;ation? And is this is the footer?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hope this helps

Saldo CCC Name of the control
=Soma([Valor Movimento]) Control source
Padrão Format
2

Sim Yes
Não No
Não No
Não No
Não No
Total Total (running Sum)
14,683cm
0,688cm
...

Pedro,

Yes, that is wierd... Exactly what do you have entered in this control?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina
No, this control is in the detail section. I've copy and past it from
the
footer section but i've also done a new one. Same result for both
control.
Kinda weird, no?
Many thanks for your help
Pedro

:

Pedro,

Is this control in the report footer?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina
Many thanks for your help. It's done but ... supose the total of
this
report
is 50. This new control shows in the first line 50, and on the 2nd,
100,
on
the 3rd, 150 and so on ...
Can you help me again?
Many thanks
Pedro


:

Pedro,

The running sum property is in the control. Go to Properties of
the
control
and once there search your choices. You will see one that is
Running
Sum
change that to Yes.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"There is a running sum property in you report properties". I'm
so
sorry,
can
you be more specific?
About making control source ...i've copy a control box of the
footer
that
were summing and put it on the detail section, like i want it,
but
no
good
result. Can you help me on this one?
Tks very much for your help.
Best regards
Pedro

:

There is a running sum property in you report properties. Then
to
get
a
total, drag down the report footer and put a textbox on it. Make
the
control
source of the textbox =sum([your field])

:

Hi everyone
I'm looking for days an answer for my problem. I'd like to
create
a
balance
on my report. Excel does it perfectly but, naturaly, access is
better
to do
it, but how?
My Qry has number_mov (sequencial), date_mov, Descr_mov,
Value_mov,
and
i'm
doing it on a report, so i 'd like to add a balance but i'm
kinda
stuck
here.
Can you help me please?
Tks a lot
Pedro

 

[Gina Whipp]

Pedro,

The control MUST BE in the footer section...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Sure. Please see below. This control is in the detail section.

Can you help me out with a trans;ation? And is this is the footer?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hope this helps

Saldo CCC Name of the control
=Soma([Valor Movimento]) Control source
Padrão Format
2

Sim Yes
Não No
Não No
Não No
Não No
Total Total (running Sum)
14,683cm
0,688cm
...



:

Pedro,

Yes, that is wierd... Exactly what do you have entered in this
control?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina
No, this control is in the detail section. I've copy and past it
from
the
footer section but i've also done a new one. Same result for both
control.
Kinda weird, no?
Many thanks for your help
Pedro

:

Pedro,

Is this control in the report footer?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina
Many thanks for your help. It's done but ... supose the total of
this
report
is 50. This new control shows in the first line 50, and on the
2nd,
100,
on
the 3rd, 150 and so on ...
Can you help me again?
Many thanks
Pedro


:

Pedro,

The running sum property is in the control. Go to Properties of
the
control
and once there search your choices. You will see one that is
Running
Sum
change that to Yes.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"There is a running sum property in you report properties".
I'm
so
sorry,
can
you be more specific?
About making control source ...i've copy a control box of the
footer
that
were summing and put it on the detail section, like i want it,
but
no
good
result. Can you help me on this one?
Tks very much for your help.
Best regards
Pedro

:

There is a running sum property in you report properties.
Then
to
get
a
total, drag down the report footer and put a textbox on it.
Make
the
control
source of the textbox =sum([your field])

:

Hi everyone
I'm looking for days an answer for my problem. I'd like to
create
a
balance
on my report. Excel does it perfectly but, naturaly, access
is
better
to do
it, but how?
My Qry has number_mov (sequencial), date_mov, Descr_mov,
Value_mov,
and
i'm
doing it on a report, so i 'd like to add a balance but i'm
kinda
stuck
here.
Can you help me please?
Tks a lot
Pedro

 

[Pedro]

OK. Original request then ... can i put this control on detail section? Cose
that's where i want it ...always ... lol

Pedro,

The control MUST BE in the footer section...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Sure. Please see below. This control is in the detail section.

Can you help me out with a trans;ation? And is this is the footer?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hope this helps

Saldo CCC Name of the control
=Soma([Valor Movimento]) Control source
Padrão Format
2

Sim Yes
Não No
Não No
Não No
Não No
Total Total (running Sum)
14,683cm
0,688cm
...



:

Pedro,

Yes, that is wierd... Exactly what do you have entered in this
control?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina
No, this control is in the detail section. I've copy and past it
from
the
footer section but i've also done a new one. Same result for both
control.
Kinda weird, no?
Many thanks for your help
Pedro

:

Pedro,

Is this control in the report footer?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina
Many thanks for your help. It's done but ... supose the total of
this
report
is 50. This new control shows in the first line 50, and on the
2nd,
100,
on
the 3rd, 150 and so on ...
Can you help me again?
Many thanks
Pedro


:

Pedro,

The running sum property is in the control. Go to Properties of
the
control
and once there search your choices. You will see one that is
Running
Sum
change that to Yes.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"There is a running sum property in you report properties".
I'm
so
sorry,
can
you be more specific?
About making control source ...i've copy a control box of the
footer
that
were summing and put it on the detail section, like i want it,
but
no
good
result. Can you help me on this one?
Tks very much for your help.
Best regards
Pedro

:

There is a running sum property in you report properties.
Then
to
get
a
total, drag down the report footer and put a textbox on it.
Make
the
control
source of the textbox =sum([your field])

:

Hi everyone
I'm looking for days an answer for my problem. I'd like to
create
a
balance
on my report. Excel does it perfectly but, naturaly, access
is
better
to do
it, but how?
My Qry has number_mov (sequencial), date_mov, Descr_mov,
Value_mov,
and
i'm
doing it on a report, so i 'd like to add a balance but i'm
kinda
stuck
here.
Can you help me please?
Tks a lot
Pedro

 

[Gina Whipp]

Pedro,

Putting it in the detail section will not get you the results you seek. You
can place it both places but again it will not get you the results you want.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

OK. Original request then ... can i put this control on detail section?
Cose
that's where i want it ...always ... lol

Pedro,

The control MUST BE in the footer section...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Sure. Please see below. This control is in the detail section.

:

Can you help me out with a trans;ation? And is this is the footer?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hope this helps

Saldo CCC Name of the control
=Soma([Valor Movimento]) Control source
Padrão Format
2

Sim Yes
Não No
Não No
Não No
Não No
Total Total (running
Sum)
14,683cm
0,688cm
...



:

Pedro,

Yes, that is wierd... Exactly what do you have entered in this
control?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina
No, this control is in the detail section. I've copy and past it
from
the
footer section but i've also done a new one. Same result for both
control.
Kinda weird, no?
Many thanks for your help
Pedro

:

Pedro,

Is this control in the report footer?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina
Many thanks for your help. It's done but ... supose the total
of
this
report
is 50. This new control shows in the first line 50, and on the
2nd,
100,
on
the 3rd, 150 and so on ...
Can you help me again?
Many thanks
Pedro


:

Pedro,

The running sum property is in the control. Go to Properties
of
the
control
and once there search your choices. You will see one that is
Running
Sum
change that to Yes.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"There is a running sum property in you report properties".
I'm
so
sorry,
can
you be more specific?
About making control source ...i've copy a control box of
the
footer
that
were summing and put it on the detail section, like i want
it,
but
no
good
result. Can you help me on this one?
Tks very much for your help.
Best regards
Pedro

:

There is a running sum property in you report properties.
Then
to
get
a
total, drag down the report footer and put a textbox on
it.
Make
the
control
source of the textbox =sum([your field])

:

Hi everyone
I'm looking for days an answer for my problem. I'd like
to
create
a
balance
on my report. Excel does it perfectly but, naturaly,
access
is
better
to do
it, but how?
My Qry has number_mov (sequencial), date_mov, Descr_mov,
Value_mov,
and
i'm
doing it on a report, so i 'd like to add a balance but
i'm
kinda
stuck
here.
Can you help me please?
Tks a lot
Pedro

 

[Pedro]

ok ... how can i get the result i want. Can you help?

Pedro,

Putting it in the detail section will not get you the results you seek. You
can place it both places but again it will not get you the results you want.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

OK. Original request then ... can i put this control on detail section?
Cose
that's where i want it ...always ... lol

Pedro,

The control MUST BE in the footer section...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Sure. Please see below. This control is in the detail section.

:

Can you help me out with a trans;ation? And is this is the footer?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hope this helps

Saldo CCC Name of the control
=Soma([Valor Movimento]) Control source
Padrão Format
2

Sim Yes
Não No
Não No
Não No
Não No
Total Total (running
Sum)
14,683cm
0,688cm
...



:

Pedro,

Yes, that is wierd... Exactly what do you have entered in this
control?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina
No, this control is in the detail section. I've copy and past it
from
the
footer section but i've also done a new one. Same result for both
control.
Kinda weird, no?
Many thanks for your help
Pedro

:

Pedro,

Is this control in the report footer?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina
Many thanks for your help. It's done but ... supose the total
of
this
report
is 50. This new control shows in the first line 50, and on the
2nd,
100,
on
the 3rd, 150 and so on ...
Can you help me again?
Many thanks
Pedro


:

Pedro,

The running sum property is in the control. Go to Properties
of
the
control
and once there search your choices. You will see one that is
Running
Sum
change that to Yes.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"There is a running sum property in you report properties".
I'm
so
sorry,
can
you be more specific?
About making control source ...i've copy a control box of
the
footer
that
were summing and put it on the detail section, like i want
it,
but
no
good
result. Can you help me on this one?
Tks very much for your help.
Best regards
Pedro

:

There is a running sum property in you report properties.
Then
to
get
a
total, drag down the report footer and put a textbox on
it.
Make
the
control
source of the textbox =sum([your field])

:

Hi everyone
I'm looking for days an answer for my problem. I'd like
to
create
a
balance
on my report. Excel does it perfectly but, naturaly,
access
is
better
to do
it, but how?
My Qry has number_mov (sequencial), date_mov, Descr_mov,
Value_mov,
and
i'm
doing it on a report, so i 'd like to add a balance but
i'm
kinda
stuck
here.
Can you help me please?
Tks a lot
Pedro

 

[Gina Whipp]

Pedro,

Put the control in the footer... Please review golfinray's post who
explains it quite well.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

ok ... how can i get the result i want. Can you help?

Pedro,

Putting it in the detail section will not get you the results you seek.
You
can place it both places but again it will not get you the results you
want.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

OK. Original request then ... can i put this control on detail section?
Cose
that's where i want it ...always ... lol

:

Pedro,

The control MUST BE in the footer section...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Sure. Please see below. This control is in the detail section.

:

Can you help me out with a trans;ation? And is this is the footer?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hope this helps

Saldo CCC Name of the
control
=Soma([Valor Movimento]) Control source
Padrão Format
2

Sim Yes
Não No
Não No
Não No
Não No
Total Total
(running
Sum)
14,683cm
0,688cm
...



:

Pedro,

Yes, that is wierd... Exactly what do you have entered in this
control?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina
No, this control is in the detail section. I've copy and past
it
from
the
footer section but i've also done a new one. Same result for
both
control.
Kinda weird, no?
Many thanks for your help
Pedro

:

Pedro,

Is this control in the report footer?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina
Many thanks for your help. It's done but ... supose the
total
of
this
report
is 50. This new control shows in the first line 50, and on
the
2nd,
100,
on
the 3rd, 150 and so on ...
Can you help me again?
Many thanks
Pedro


:

Pedro,

The running sum property is in the control. Go to
Properties
of
the
control
and once there search your choices. You will see one that
is
Running
Sum
change that to Yes.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"There is a running sum property in you report
properties".
I'm
so
sorry,
can
you be more specific?
About making control source ...i've copy a control box
of
the
footer
that
were summing and put it on the detail section, like i
want
it,
but
no
good
result. Can you help me on this one?
Tks very much for your help.
Best regards
Pedro

:

There is a running sum property in you report
properties.
Then
to
get
a
total, drag down the report footer and put a textbox on
it.
Make
the
control
source of the textbox =sum([your field])

:

Hi everyone
I'm looking for days an answer for my problem. I'd
like
to
create
a
balance
on my report. Excel does it perfectly but, naturaly,
access
is
better
to do
it, but how?
My Qry has number_mov (sequencial), date_mov,
Descr_mov,
Value_mov,
and
i'm
doing it on a report, so i 'd like to add a balance
but
i'm
kinda
stuck
here.
Can you help me please?
Tks a lot
Pedro