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
--
Thank you in advance!!!!


"daisy" wrote:

> 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!!!!