size of a table in an access database

[iman]

hi,

i try to know the size of a table in access database,then i would to transform it to a string value,but i don't success.

i attached a jpeg image of my code.

in the concatenated string must appear "rapportx.png" where x represent the size of the table

[MarcoMauri · Accepted solution]

You should use "Number to decimal string" to convert the number to text.

Please note also that the "Array size" returns a 2D array in yuor case: so you have two dimensions.

Last, but not least, to count the number of records, it wuold be more efficient to use the sql count() function:

http://www.w3schools.com/sql/sql_func_count.asp

Regards,

Marco

[iman]

thanks, i split the 2D array then i use number to decimal string ,it work