Append & Update a table

  • Thread starter Thread starter dreamsoul620 via AccessMonster.com
  • Start date Start date
D

dreamsoul620 via AccessMonster.com

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
 
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
 
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
'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
Click to expand...
[quoted text clipped - 19 lines]
Thanks,
Crystal
Click to expand...
Click to expand...
 
Back
Top