[I'm a newbie] Adding the content of 2 cells in Mask with Macro

[MrRud]

Hi guys.



I have a problem: I created a table from a DB and a mask: i Wanted to create a macro that writes in a column the sum of 2 different elements of another column.

Example:
I have this series of numbers:

78
56
95
23
14
75
63

I want to create a macro that writes in another column the current element of the record with the current - x element, it would be something like this:

78 -
56 -
95 95 + 78
23 23 + 56

etc.

Thanks for your help

[NTC]

No way, as currently constructed. There needs to be some ID data that cross references records so a db would know that 78 goes with the 95. The positional order is not sufficient - there must be data in the records themselves that cross references.

Macros are not in general what you should be focusing on. Math & data manipulation can occur via queries or via VBA triggered in controls in forms. Either approach is viable and will depend on whether you do this auto math during human data entry (at the form level) or after entry when working with a fixed table (query).

Hope this helps.