Re: Update with calculation

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Lynn Trapp (ltrappNoSpam_at_ltcomputerdesigns.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 12:21:22 -0500

Then put the calculation in a saved query that you use as the record source
for your different reports. You only have to enter the calculation once. 

-- 
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
"Susan L" <anonymous@discussions.microsoft.com> wrote in message
news:61a901c42e32$652c96c0$a401280a@phx.gbl...
> I'm trying to avoid having to enter the formula every time
> I prepare a report etc.  Just have the number even in the
> table.  Is it possible?
> >-----Original Message-----
> >Is there a reason that you need the calculation stored in
> the table? If you
> >can calculate it on the fly for the form, as you have
> apparently done, then
> >you can calculate it on the fly anytime you need it -- 
> query, report, etc.
> >
> >-- 
> >Lynn Trapp
> >MS Access MVP
> >www.ltcomputerdesigns.com
> >Access Security: www.ltcomputerdesigns.com/Security.htm
> >
> >
> >"Susan L" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:633701c42e2c$0a2bae10$a301280a@phx.gbl...
> >> How do I update a table with a calculation performed in
> a
> >> form?  I enter the data in the form, have a field for
> the
> >> total, have the correct calculation showing in the form,
> >> but the field in the table stays at 0.  I would like the
> >> calculation to be permanently saved in the table.
> >> Thanks in advance
> >
> >
> >.
> >

Relevant Pages

  • Re: How do I print a report without showing any zero fields
    ... > I do not want these zero entries to show on my report which is set to ... >> MS Access MVP ... >>>I want to display a blank or nothing on the report, ...
    (microsoft.public.access.reports)
  • RE: doing calculations using Query Vs Report using Access
    ... I use Expressions in a report to do the calculation, ... Compact and repair your database. ... Make sure all PCs have a copy of the changes. ...
    (microsoft.public.access.reports)
  • RE: doing calculations using Query Vs Report using Access
    ... How about providing some of the "Expressions in a report to do the ... I use Expressions in a report to do the calculation, ... Compact and repair your database. ... Make sure all PCs have a copy of the changes. ...
    (microsoft.public.access.reports)
  • Re: vb Procedure/process coding help
    ... Write a function that does the calculation and save the function in a VBA ... module instead of a class module. ... procedure no matter if the report or the form is run. ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • RE: Calculation Using IIf
    ... This is a cumulative report that shows data from ... the percentage is a "rolling" calculation ... "Susan L" wrote: ... I have a crosstab that places the data in rows, and the totals in columns by ...
    (microsoft.public.access.reports)