append query

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Autonumber field in Excel that behaves the same as Access 0
Adding data to MS Access from csv file 0
QBF & Query Malfunction 0
Access 2010 DB not fuctional with multiple users 2
create append query resulting in multiple new records 4
Make table query: [Enter 1] AS Test 1
Date update in append query 6

Top