Report Error Message

[peterengland]

Trying to create a report based on data from two tables. When I go through the wizard and click finish the following error message appears:

“The wizard is unable to preview your report, possibly because another user has a source table open in exclusive mode. Your report will open in design view”

I am confused as I do not have any other table open. Also when you try to load the report the following message appears:

“Type mismatch in expression”


My guess is it is something to do with the relationships between the tables but I have no idea how to sort this out. Any help solving the problem would be much appreciated
Regards
Peter

 

[Joe4]

If you tables are related, you *usually* want to create a query linking the two tables and selecting all the fields you wish to display in your report. Then, you would use this query as the Control Source of your report.

 

[peterengland]

Thank You

Cheers for you respons it's sounds so obvious when you say it. Thanks again