thanks for your prompt reply.

i made the changes you suggested enclosing reserved keywords in square brackets. it seems to be working fine now.

thanks also for the suggestions to improve...