Updateting WO Number

[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

 

[Guest]

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]

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

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#.

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