How to make a "self-added" field in form or query?

[Guest]

In Excel or Q&A, I can make this field in each row like "D1=D1+1", how to do
this in Access ? Please help. Thank you.

 

[JohnFol]

In a form? Report? query? vba?

 

[Guest]

Thanks JohnFol for your response. Actually in a form with 1 column of bined
data, I want to show the accumulated balance in a 2nd column with unbined
field.

How to do it in :
1. the field expression in the form ?
2. in a query as the data for the form ?

Please help. Thanks.

Samuel SW Leung

 

[JohnFol]

In an unbound box you can set the control source to be a function. For
example
=Field1OnTheForm + Field2OnTheForm


in a query , you can add an expression in the next available column. Try
this in the sample NWind and you will see what I mean

SELECT [Order Details].UnitPrice, [Order Details].Quantity,
[quantity]*[unitprice] AS Total
FROM [Order Details];