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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" wrote:

> In a form? Report? query? vba?
>
>
> "Samuelswleung" <Samuelswleung@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:FDA87889-702C-465F-8E1E-23E13AB58158@xxxxxxxxxxxxxxxx
> > 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.
>
>
>
.

Relevant Pages

  • Re: Adding 2 values in 2 queries
    ... "JohnFol" wrote: ... > Have you looked at setting the controlsoruce of the text box on the report ... >> in the 4monthEligibleIDs query. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Like Query
    ... It showed me all records instead of limiting to what's chosen on the form. ... "JohnFol" wrote: ... >>I have a query which picks up information chosen from a drop down list on a ... >> (where the ccentre holds the first four digits to the code) ...
    (microsoft.public.access.queries)
  • Re: Query to get data automatically
    ... "JohnFol" wrote: ... > That sounds like you are repeating the company data in 2 separate tables. ... >> And I need to make a query to insert the company name and data and then ...
    (microsoft.public.access.queries)
  • Re: Word Doc Search Query from Access
    ... the query i have below is all i have... ... i have tried entering a filepath, but to no avail, it doesnt search. ... "JohnFol" wrote: ...
    (microsoft.public.access.queries)