I have lined two tables exmaple below
Table 1 Table 2
1 John 1 John 7
2 Jane 3 Claire 9
3 Claire
4 Sarah
I would like to return
John 7
Jane 0
Claire 9
Sarah 0
While the 0 can be blank I still want to return the name, and do caluclations on the number. i use Crystal 8.5.
Thanks
Table 1 Table 2
1 John 1 John 7
2 Jane 3 Claire 9
3 Claire
4 Sarah
I would like to return
John 7
Jane 0
Claire 9
Sarah 0
While the 0 can be blank I still want to return the name, and do caluclations on the number. i use Crystal 8.5.
Thanks