Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to display RowNo() for only the specified items in the table?
ex)In table X, I want to assign row numbers only for Region, City and Sales data. I would like to ignore Customer data, is that possible?
----------------------------
Table X:
Region,
City,
Sales,
RowNo() as RowID,
Customer
resident City;
----------------------------
Hi, I'm not sure to understand your question...maybe with Autonumber()?:
Autonumber(Region&'_'&City&'_'&Sales) as RowID
Using this, rows with the same region, city and sales will have the same ID.