Hi,
I have created a report that shows records from different tables using inner join. It was working well.

Now I m getting problem in opening the same report.

Is it possible that it may be due to number of records in tables??
One thing, I have used CDate() function to convert text to Date for comparison in query.

How do I get rid of it??
I am using MS Access 2007.

Thanks in advance.

Hello. In order to even begin to answer this question, we'd need to know at least

• What are the tables in question?
• What are the fields that are joined?
• What are the joined fields' join type?
• What are the joined fields' data types?
• What error message are you gettting when you open the report?

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

Thanx for reply.

I got it.
There was problem in date conversion.

Once again,
Thanx