hi,


There are 2 tables in my database with the same structure but different data (work and private).I want to keep these tables separated , but i need to make a rapport with both data in it.
Is that possible ?

TIA and a happy new year to all.

Since you placed this in the "Access Queries" forum, I beleive you are already on the track towards what I would suggest! If you create a query based on both of those tables (you will need to have a relationship between a key or matching field in each), you can then base your report on that query.

Without knowing more about your table structure, or what information you want on the report, I can't be more specific. If you're unsure about how to do relationships (or queries from multiple tables), please post back with some more information.

Hope this helps...

got it , thx for your help

You're welcome