Hi all

Does anybody knows if is possible to create a report that combines data from 3 different tables?

Explain:

I have a database with some tables, three of them are t_tasks, t_services and t_various. Each of these tables has, among others, the following fields: operator_ID, date, job_description, work_hours, cost. What I need is to search for an operator and to produce a report categorized by a) job_description and date, with the data from the three tables.

Is this possible? Any help will be valuable...

Thanks

nlo

It is posible if you have relationships between the tables. It is difficult to say much more without a lot more detail.

Hi Ralph, thanks for your answer

The database has also a table, t_operators, with the standard data of the operators (operator_ID, name, address etc). Each one of the t_tasks, t_services and t_various tables has a relationship with t_operators via operator_ID. If you need more info let me know.

Thanks