beginner VBA to create 2 columns

  • Thread starter Thread starter daisy
  • Start date Start date
D

daisy

Hi, I haven't written in vba in Access before so I'm not sure what to write
or what my best approach is to solve my dilemma

I am starting a db it'll have a main table with several columns of data.

Each month I will have data to import into the larger table. The problem is
that I need to be able to create 2 fields that compare from other fields. I
know it's not best to have calculated fields in your tables but for our
purposes we need it.

You have a dataset where everything is collected (currently all in Excel and
this is manually done)
The data has several fields but here is an example of an abbreviated version:
Data

Booking Qtr Mbr ID Member Event TotalPd

2008-12 1111111 ABC Initial
$500
2009-5 1111112 BCD Initial
$250

New Data coming in

Booking Qtr Mbr ID Member Event TotalPd

2010-1 1111111 ABC Renewal $1000
2011-1 1111111 ABC Renewal 2 $1500

I want to be able to append the data but create a field that compares the
Initial Event TotalPd to the Renewal (Delta) and then another column that
compares the different renewal events to each other - for example Renewal and
Renewal 2

The commonality between them is their name & ID

Thank you in advance!!!!
 
I agree it's not ideal to do this - if it ends up being okay not to add the
columns how in the query would I show the comparison for any individual mbr

The Event distinguishes the Initial vs Other?

Thanks again
 
Back
Top