append query

  • Thread starter Thread starter Trinity
  • Start date Start date
T

Trinity

I am not real good with queries so I dont know if this is
possible or not. I need to compare a value in a field in
one table (one record only) to a field in another table
(with multiple records). If they are the same I wish to
add the value of 1 to a the corresponding record in a
third table. Does this make sense? Can you give me some
ideas where to start?

THANKS
 
I am not real good with queries so I dont know if this is
possible or not. I need to compare a value in a field in
one table (one record only) to a field in another table
(with multiple records). If they are the same I wish to
add the value of 1 to a the corresponding record in a
third table. Does this make sense? Can you give me some
ideas where to start?
Click to expand...

Your comparison sounds suspicious. If there is a one to many
relationship, there might be zero, one, or many records in the
[Another] table which match. Do you want to increment the field in
[Third] if any record matches? or increment it by one for each match,
or what?
 
Back
Top