I need to design a table or query that can be exported to excel then copied into a write protected upload spreadsheet.
The fields in the upload spreadsheet are:
Order#
Sequence#
SKU
Qty
The sequence number is 1, 2, 3 , etc for each SKU then restarts at each new order #.
I can't figure out how to assign the sequence number in my query or table before exporting it.
Any help would be much appreciated. Thanks.
The fields in the upload spreadsheet are:
Order#
Sequence#
SKU
Qty
The sequence number is 1, 2, 3 , etc for each SKU then restarts at each new order #.
I can't figure out how to assign the sequence number in my query or table before exporting it.
Any help would be much appreciated. Thanks.