I have uploaded a report which will return the password for a selected individual. The report will only work if the person logged in is an administrator. 

http://forums.nbn.org.uk/uploads.php?file=JNCC_Get_Password.XML

Save the file.  Make sure R6 is closed. Copy the file  into the report folder of the R6 system. The report runs as a quick report from the Name and Address list in R6. Find the person on the list and then right click and choose quick report.  Choose  Information then JNCC_Get_Password.  Re-enter the password of the logged in Administrator and click on OK. The individual's password will be returned. If blank then either the person running the report is not an administrator, the admin password is wrong or  individual chosen is not a user.