Inserting Data

[markedback]

I am trying to insert a single column of data ('calls') in a table from another table.

The destination table has a column with similar data which needs to be corrected with the data from the source table.

The 'calls' column in the source table is created from another table (call log). The 'calls' column in the source table is the sum of calls attended by the sales reps.

The call log table records the type of calls (new, follow-up, referred ..... ). In the source table these calls are summed up (counted) and the totals are recorded in the 'calls' column against the employee number of the rep.

This data needs to be updated regularly in the destination table as the number of calls handled changes daily.

When I tried to use the append query to to this, I keep getting the error that "Access didn't add records due to validation rule violations" even though I haven't set any validation rules.

Is there any way around this problem? Or Am I trying something that is not fundamentally possible?

 

[fneily]

Seems it should be posted in Microsoft: Access Tables and Relationships.

Can you post your tables and their fields? The reason I'm asking is that you don't stored sums or calculations in tables. This is against normalization. It seems if you're tracking calls, there'll be a date/time stamp. In combination with an employeeID, you'd be able to get any counts you want for any reporting.

If whoever didn't normalize your tables, then say "oops!" and see:
Fundamentals of Relational Database Design

http://r937.com/relational.html

 

[PHV]

Seems you want an UPDATE query instead of an APPEND ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886