Append & Update a table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dreamsoul620 - 20 Mar 2006 20:00 GMT

I need to be able to append data if the entire record is new and update if
only part of the record is new. I am still somewhat new to Access and am
confused as to how to do this.
I have my three queries that all append different records to me EARLY_POINTS
table. The fields are as follows:
EMPNAME
EMPNUM
DATE
USTR1
FCLASS
LENT1
MINUTES
POINTS
REASON

Points and Reason will always be a set value no matter what else changes. I
have a multiple index set up with EMPNAME, EMPNUM, and DATE so that no
duplicates appear if the append query is ran multiple times. If the number
of minutes changes from one day to the next, I want this to appear in my
table. Any help is greatly appreciated.

Thanks,
Crystal

Reply to this Message

mscertified - 20 Mar 2006 20:26 GMT

You need to be clearer in what you want. What do you mean by 'append data',
what do you mean by 'if the entire record is new' and what do you mean by
'only part of the record is new'?

-Dorian

> I need to be able to append data if the entire record is new and update if
> only part of the record is new. I am still somewhat new to Access and am
[quoted text clipped - 19 lines]
> Thanks,
> Crystal

Reply to this Message

dreamsoul620 - 20 Mar 2006 22:40 GMT

The EMPNAME, EMPNUM, DATE, and REASON must be unique as a group. For
instance, the same employee can only be late once on a certain date, but they
could also leave early on the same date. The REASON would differ, so a new
record would be appended. If I run my query and this group of fields is
identical, then all other fields would update as needed. For instance, the
POINTS and MINUTES fields may have changed due to a clock malfunction and
need to updated and corrected. This is the "part" that I refer to.

>You need to be clearer in what you want. What do you mean by 'append data',
>what do you mean by 'if the entire record is new' and what do you mean by
[quoted text clipped - 7 lines]
>> Thanks,
>> Crystal

Signature

To be the best, you have to first give up everything.

Reply to this Message