Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Looks like you want to treat Asset Code as text field - see attached
Looks like you want to treat Asset Code as text field - see attached
Hi,
Maybe you can use Num([Asset Code],'00000000') in your load script to force 8 digits with leading zero.