ukaquanaut
Registered User.
- Local time
- Today, 03:18
- Joined
- Feb 8, 2012
- Messages
- 33
Hi Guys
I'm helping to assemble data that will be passed to SAP as flat csv files to populate some of our stock. I need a column of sequential number just 1 to n, no fancy conditions or groups.
However, when I select stock from location A everything I need is there, but the RowNum (1 to n) simply reflects the AutoNunber ID for the table TblSAPCoded.
I have tried a dozen combinations for this Dcount clause but I'm failing miserably, I'm hoping you guys can point me in the right direction.
I have attached three pictures to show.
I'm helping to assemble data that will be passed to SAP as flat csv files to populate some of our stock. I need a column of sequential number just 1 to n, no fancy conditions or groups.
However, when I select stock from location A everything I need is there, but the RowNum (1 to n) simply reflects the AutoNunber ID for the table TblSAPCoded.
I have tried a dozen combinations for this Dcount clause but I'm failing miserably, I'm hoping you guys can point me in the right direction.
I have attached three pictures to show.