Create a report with information from two different tables

[chavezduq]

Hello, Im have a little troube, and was wondering if anyone could help. My question is I need to create a a report. My report is going to use data from two different tables. Furthermore, I want to sort the data by a field in one of the tables and I would like the related data in the same rows to sort with it in both tables. Any thoughts???

In short:

Table 1 has names, table 2 has "serial numbers" (3 sets) and I need them to be side by side. I want to sort by the serial numbers, and I want the names to sort with the corresponding serial number.

Any help would be greatly appreciated

Thanks

 

[dhookom]

Just create a query based on both tables and use this query as the record source of your report.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]