Hi everyone,
I am not a complete Access newbie, but for my company it is stretching and growing my skills.
Here is what I need to do:
Create a report for one client with info from multiple tables.
I understand creating a query would be my first step, but I have many fields, and it's not coming out how I would like.
I have separate tables for:
Clients
Training 1
Training 2
Training 3
In my main page for the Client, I have tabs, and one of them includes a sub form for Training 1 - 3. I would ideally like to print that tab but that doesn't turn out pretty.
I had the 3 trainings combined in the Clients table previously, but it did not work out well, so I had to split them up. Each Training table contains dates and information relating to that specific training.
What I need is a report that gives me info from all 4 tables...but because of the different dates...it's over 20 fields. I need a handful from Client, then everything from Training 1 - 3.
Anything I try gives me duplicates or seems overly complicated:banghead:
Any suggestions?
I am not a complete Access newbie, but for my company it is stretching and growing my skills.
Here is what I need to do:
Create a report for one client with info from multiple tables.
I understand creating a query would be my first step, but I have many fields, and it's not coming out how I would like.
I have separate tables for:
Clients
Training 1
Training 2
Training 3
In my main page for the Client, I have tabs, and one of them includes a sub form for Training 1 - 3. I would ideally like to print that tab but that doesn't turn out pretty.
I had the 3 trainings combined in the Clients table previously, but it did not work out well, so I had to split them up. Each Training table contains dates and information relating to that specific training.
What I need is a report that gives me info from all 4 tables...but because of the different dates...it's over 20 fields. I need a handful from Client, then everything from Training 1 - 3.
Anything I try gives me duplicates or seems overly complicated:banghead:
Any suggestions?