Update Query

[cktcPeterson]

I am new to update queries and need some guidance.

I have a form that I will filter by Invoice Number

I have an unboud field that I can type in the check number. Sometimes I have over 50 records that need the check number added.

I would like to type in the check number and it update the filtered fileds.

Or if there is a more logical way? I can do it by a prompted too.

"Add Check Number"

I hope that made sense. I am flexiable on this process sense I am learning.

 

[theDBguy]

Try this on a backup copy first.

UPDATE TableName SET [Check Number] = [Enter Check Number] WHERE [Invoice Number] = [Enter Invoice Number]

(untested)

 

[plog]

UPDATE queries are a red flag for improperly structured databases. Not a smoking gun, but they always make me want to investigate. In a database you don't want the same data all over the place, you want it in one spot then you simply JOIN to it.

Can you complete your Relationship Tool in Access, take a screen shot and post it back here? Also, tell us what field(s) this check number is going into.

 

[cktcPeterson]

Would a find and replace be a better option? I have my payment table to have the invoice number and check number for each payment.

My datasheet form I have it filtered to the invoice number. I can run a code??? to find blanks and replace with what is in unboud field?