Good afternoon All.
I am working with my first update query. It's working well expect in one instance I need to to look at the last record with no value, add 1 to that value (not update it) and use the new number for all records with no value. I'm updating other information in these records at the same time.
What I'm trying to do is assign pack slip numbers to records and increment them by 1.
If I'm clear....
Thanks in advance.