I have a problem of calculating the total in an Access Field and then Display
it again.

you can add a textbox to form/report footer and set it controlsource
property to:
=Sum([MyField])

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"Access Column Calculation" <Access Column
(E-Mail Removed)> wrote in message
news:772D5C5C-7A77-4FF0-A54C-(E-Mail Removed)...
> I have a problem of calculating the total in an Access Field and then
Display
> it again.

Access Column Calculation wrote:
>I have a problem of calculating the total in an Access Field and then
> Display it again.

You can do this in a query, report or form, but you can not do it in a
table. Tables are only buckets for storing data and defining fields. All
other functions should be done using queries, reports or forms.

--
Joseph Meehan

Dia duit

> you can add a textbox to form/report footer and set it controlsource
> property to:
> =Sum([MyField])

That gives rise to a more exotic question -- Does Access support COMPUTE
[BY] [WITH ROLLUP] that we can do in SQL Server?
--
Peace & happy computing,

Mike Labosh, MCSD MCT
Owner, vbSensei.Com

Sorry, i think no

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"Mike Labosh" <mlabosh_at_vbsensei_dot_com> wrote in message
news:%(E-Mail Removed)...
> > you can add a textbox to form/report footer and set it controlsource
> > property to:
> > =Sum([MyField])
>
> That gives rise to a more exotic question -- Does Access support COMPUTE
> [BY] [WITH ROLLUP] that we can do in SQL Server?
> --
> Peace & happy computing,
>
> Mike Labosh, MCSD MCT
> Owner, vbSensei.Com
>
>