Its true that the database is not designed well, i don't want to go in details why its not designed well but this is the only fields and data we...

Dear Christian, thank you v.much for your efforts.

regarding your comments , i am able to add the first Name column as field but i highlighted that to allow you...

Dear Friends

thank you for your kind assistant, i had run the query which reduce the gap and near to complete my needed result. but i noticed the following changes after...

Hi Lutz

V. sorry for that , i didn't mean to send a remainder. it was correction of a post i thanked Mr. Lowell for cleanup my question and make...

waiting for your kind help