Updating Multiple fields with the same number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Access Gurus,

I have a group of empty fields attached to purchase orders I need to update
with the same number. Right now, I am having the update query change the
value to OrderID plus 5000 if the PO value is null. Would I need to set the
formula to add the MAX value of OrderID instead of OrderID? Thanks for any
help.

Rich S.
 
Maybe. Or Maybe you would prefer to use a negative number, such as -1 to
identify these records. Or just use some huge number that you will never reach.
That way you will know that this is an artificial number that is being used.
 
What I need to do is assign the same PO number to multiple items. Say I
order 4 different items from the same company, I need them all on the same
PO. I already have an update query that will update null PO fields, but I
need it to assign the same number ex: PO 56789 to the 6 items with a null PO.

Hope this clears it up.
 
Back
Top