Linking tables

[Anonymous]

I am trying  to create a report using data from two different tables and linking them by using an 8 digit number asset

Unfortunately this 8 digit number is not a sequential system generated but manually entered and I have a number of data lines which are same number but not prefixed to make up 8 digit. Because of this they are not linking properly can anyone help with a solution.

Table 1

Asset Code         Asset Desc          Asset Value       

00022500             BMW                     10,000

22500                    SAAB                     5,000

Table 2

Asset Code         Asset Life            Asset Location

00022500             5 years                  London

22500                    2 years                  Swansea

[Digvijay_Singh · Accepted solution]

Looks like you want to treat Asset Code as text field - see attached

[Anonymous]

Hi,

Maybe you can use Num([Asset Code],'00000000') in your load script to force 8 digits with leading zero.