Create a balance on every line of a report

  • Thread starter Thread starter Pedro
  • Start date Start date
P

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
 
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])
 
"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

golfinray said:
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 said:
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
Click to expand...
Click to expand...
 
golfinray said:
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 said:
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
Click to expand...
Click to expand...
 
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

Pedro said:
"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

golfinray said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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


Gina Whipp said:
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

Pedro said:
"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

golfinray said:
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
Click to expand...
Click to expand...
Click to expand...
 
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

Pedro said:
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


Gina Whipp said:
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

Pedro said:
"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
Click to expand...
Click to expand...
Click to expand...
 
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

Gina Whipp said:
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

Pedro said:
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


Gina Whipp said:
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
Click to expand...
Click to expand...
Click to expand...
 
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

Pedro said:
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

Gina Whipp said:
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

Pedro said:
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
Click to expand...
Click to expand...
Click to expand...
 
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
....



Gina Whipp said:
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

Pedro said:
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

Gina Whipp said:
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
Click to expand...
Click to expand...
Click to expand...
 
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

Pedro said:
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
...



Gina Whipp said:
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

Pedro said:
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
Click to expand...
Click to expand...
Click to expand...
 
Sure. Please see below. This control is in the detail section.

Gina Whipp said:
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

Pedro said:
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
...



Gina Whipp said:
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
Click to expand...
Click to expand...
Click to expand...
 
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

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

Gina Whipp said:
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

Pedro said:
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
Click to expand...
Click to expand...
Click to expand...
 
OK. Original request then ... can i put this control on detail section? Cose
that's where i want it ...always ... lol

Gina Whipp said:
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

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

Gina Whipp said:
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
Click to expand...
Click to expand...
Click to expand...
 
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

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

Gina Whipp said:
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

Pedro said:
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
Click to expand...
Click to expand...
Click to expand...
 
ok ... how can i get the result i want. Can you help?

Gina Whipp said:
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

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

Gina Whipp said:
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
Click to expand...
Click to expand...
Click to expand...
 
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

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

Gina Whipp said:
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

Pedro said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top