Need to check to see if a matching record exists before I append a new

[titleist0813]

I am writing a enterprose wide attendance database, and need to be able to append a "counseling needed" record to a seperate table so that a report can pop up based off of this table.

I need to add the record to the table if there is not a record that matches "needed date", "EE Number", "counseling type", and "points accumulated" across both records.

Is there an easy way to do this? I have written access databases for 12 years, but have been out of the loop for the past two years, and you wouldbe suprised what all you can forget in that much time!

Any help will be greatly appreciated!

 

[Gruuuu]

It's an access database?
Couldn't you just run a query to find that exact combination, and not update if it's found?

 

[dhookom]

Where are the values for your insertion coming from? Are they in a table or where?

Duane
Hook'D on Access
MS Access MVP