Updateting WO Number

B

Brent

I have a query that is looking at the assigned date and if it is not null it
goes to the WO# field and adds the next number to it using the
Nz(DMax("[GldWoNum]","[tblWOFile]"),0)+1 command. I am doing all of this
in an update query. The problem is it assigns all of the items ( We may
have updated 20 work orders) the same WO# and doesn't redo this function for
each record. Any thoughts?

Thanks
Brent
 
G

GrandMaMa

Add a one character field(there are several ways but this is my favorite way)
to the WO# record. After you have assigned to WO# insert a character in that
field and then check to see that the character is not there before you add a
new WO#.
 
B

Brent

Sorry but I'm a little confused.. can you give an example?

GrandMaMa said:
Add a one character field(there are several ways but this is my favorite
way)
to the WO# record. After you have assigned to WO# insert a character in
that
field and then check to see that the character is not there before you add
a
new WO#.

Brent said:
I have a query that is looking at the assigned date and if it is not null
it
goes to the WO# field and adds the next number to it using the
Nz(DMax("[GldWoNum]","[tblWOFile]"),0)+1 command. I am doing all of
this
in an update query. The problem is it assigns all of the items ( We may
have updated 20 work orders) the same WO# and doesn't redo this function
for
each record. Any thoughts?

Thanks
Brent
Click to expand...
Click to expand...
 
Top