Jack, Received your reply. You’ve solved my problem. I was trying to bring all data into a table and create a report based on that table. Therefore, I must update the table with “ to be displayed” data. You remind me that I can pull all information into a query and then create the report from the query. That was the last snag in my project development. Last week I completed my final test. Starting this week I will refine it -- adding some user friendly messages etc. Many thanks for your help in my project. Chris