I need to add a new field to an existing action query, using Access 2002 on the front end and SQL 2005 on the back end. I have added my new field to the existing action query, but the results are not what's wanted. The new field shows up on the affected report, but the data is not imported to the report. My guess is that I need to link the two tables in the action query where SQL is pulling the data from, but I'm not sure how to do that. The existing action query only has one table and not the one I need to pull the data from. Can someone tell me if I'm on the right track and if so, how to proceed? I've already been warned to backup the existing tables before executing the modified query. Thanks in advance to anyone who can help.