RE: Select Query to create a Total field

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

Your calculated column will update as soon as you update a field value in the
record.

What is happening in your form when you edit a field value?

--
Duane Hookom
Microsoft Access MVP


"Jim Dudley" wrote:

I realize that I do not want to store the value but I want the table and
related form to show the results of Expr1: as a column or field in both.

When an edit or change is made to one of the underlying fields that part of
the query total expr: What to I have to do to get the new result reflected in
the data*** view? Do I have to close and rerun the query or will the
refresh function update the reslults?
--
Thanks in advance...

Jim


"Duane Hookom" wrote:

Jim,
You generally don't want to store a value that can be calculated. Also,
adding values across fields in a table generally suggests an un-normalized
table structure.

Apparently your query already works. I would change the name of "Expr1" to a
name that makes sense. The calculation will update when the record is updated.

--
Duane Hookom
Microsoft Access MVP


"Jim Dudley" wrote:

I have a query that selects records form a table.
I Total 5 fields in each record and want the total result to appear in my
table and split form.

The query works and returns the totals I require in a column Expr1.


How do I get these results to appear as a column in my table?

How do I get this result to appear in a field in my split form and
underlying table?

If I edit or change a value in one or several of the fields, how do I get
the query to update the data in the table and form.

Any help for this novus would be appreciated.

Thank you


--
Thanks in advance...

Jim
.

Quantcast