Hi

May you assist me with a multitable report that does not display records contained in the form. The single table report do display the records.

I used the report wizard to create a report from two or more tables but the records are not displayed. Is there something I nedd to do differently when creating report for two or more tables that I can get the records on the report.

Thank you in advance.

Is the query behind the report producing any results? If not, then your problem is your query / criteria maybe

Col

Is the query behind the report producing any results? If not, then your problem is your query / criteria maybe

Col

I used the report wizard to create the report. I'm using Access 2003 version for my database.

Note: The report for one table does displays records.

The report wizard is the only way I know to create a report. I'll appreciate if you would assist me with way to follow to create a report for multi tables that displays records.

Thank you

Reports should be based on queries not the tables. Create the query first with the required criteria and the fields you need to show in the report, make sure it returns the records you require.

Then use the report wizard to create the report using the query as the report's recordset. You can then go into the report design and edit it to fine tune the presentation of it.

I always use the wizard to do the main work of creating the report, then personalise it afterwards.

Col

Is the query behind the report producing any results? If not, then your problem is your query / criteria maybe

Col

I used the report wizard to create the report. I'm using Access 2003 version for my database.

Note: The report for one table does displays records.

The report wizard is the only way I know to create a report. I'll appreciate if you would assist me with way to follow to create a report for multi tables that displays records.

Thank you

[QUOTE=DipIT;593638]I used the report wizard to create the report. I'm using Access 2003 version for my database.

Note: The report for one table does displays records.

The report wizard is the only way I know to create a report. I'll appreciate if you would assist me with way to follow to create a report for multi tables that displays records.

Thank you

I've told you that already. Do it in a query, you can have many tables in there (providing the links and relationships are correct)

Col

A report has to be based on a single dataset. In the report you have created that works, your single dataset is the table.

If you want two sections in your report, one for each set of data, then you really need two subreports. This is simply two individual reports embedded in one main report. Each subreport based on a single table.

However I suspect you want one report that is based on data drawn from several tables. You can't do that directly from the tables, you need to combine the data together to give you the single dataset. The way you do that, as Colin says, is to use a query. If you don't know what a query is, you need to do quite a lot of studying before you can get any further.

Thanks very much as I managed to get records displayed on the report using a query.