Recent content by kivenage

what does it mean to have key violations? i have an append query that adds new users to a table from another linked table. but it says that none were added due to key violations. i've checked to make sure that the fields involved have the same attributes. has it anything to do with PK and FK...

i want to update a field "Target.Performance" from one database with the total sum of these fields "Contacts.Time + Contacts.IntTime + Contacts.TravelTime" from a different database. i have the Contacts table linked to the database with the Target table here's my statement: UPDATE Target SET...

i have an access database that is hoping to link to certain tables in a PERVASIVE SQL database via odbc. i plan to link certain tables and draw data from the pervasive db and store it into access db every night. i'm new to access, and so would it automatically check and dump duplicates? is it a...

i'm trying to use a SetValue macro in access to update a field in a table with the results of a query. is that possible? if so, my query calculates the total number of hours serviced by a team of workers. the field of this calculated sum is 'SumOfTarget' my SetValue macro has Item...

i've got a query that calculates the total number of hours done by a team of workers. how do i get the result of that sum query to reflect in 'collective_performance' in my 'target' table?

i've got a query that calculates the total number of hours done by a team of workers. how do i get the result of that sum query to reflect in 'collective_performance' in my 'target' table?

thanks guys, i'll see if i can get it working. =0)

hi all, here's my prob... one person can have more than one job. so how do i reflect that in the datasheet? i have staff_id job 1234 job1 job2 can this be done without having a duplicate staff_id? thanks