Folks,
I am trying to add a field in a table (via a query) to set a flag to either 1 or 0, depending on the previous value of one of the fields. i.e.
Request No Order No Flag
12345 456789 1
12345 654321 0
12345 987654 0
12346 658956 1
12346 785478 0
etc
I can do it in Excel (if a2=a1, 0,1) but having problems in Access.
Can anybody help please.
I am trying to add a field in a table (via a query) to set a flag to either 1 or 0, depending on the previous value of one of the fields. i.e.
Request No Order No Flag
12345 456789 1
12345 654321 0
12345 987654 0
12346 658956 1
12346 785478 0
etc
I can do it in Excel (if a2=a1, 0,1) but having problems in Access.
Can anybody help please.