Jan 6 2005, 10:34 AM
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.
Jan 6 2005, 10:39 AM
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...
Jan 6 2005, 02:15 PM
got it , thx for your help