To Create Report from many tables

[anil_gupta2k]

Hello everyone..

I have developed a database in MS Access
Basically it contains

4 tables

1st Table -> Information
2nd Table -> Item Details
3rd Table -> Vendors Details
4th Table -> Member Details


I usually enter details in Information table and item detail tables ( basically more than 1 items are entered) than I add vendor details..The whole thing is done through form and working fine.

The whole thing is done for raising Tender Enquiry.(For which i have developed the program)

I generally generate report using word mail merge and using the table as database. Before that i had only 1 table but in this version i have four table and in mail merge we can connect only one table.

So i cannot resolve this problem...

I have tried MS Access Report but not possible ...as data is to be inserted as per our requirement.

Looking for a response

Anil

 

[HiTechCoach]

I would recommend using a report for the main table and a separate sub report for each related table to pull data. Access does handle this very well. While a word merge does not handle this very well.

 

[anil_gupta2k]

Hi

First of all i would thanks for your valuable suggestion.

I have got ur idea

But i am facing the problem that i want to insert many data in a sheet i mean to say on the report

for examle

if i have more than 1 vendors ( take 4 vendors name) under one id but in vendors details table it show 4 records. than how i will insert it as per our requirement...ie. as we do in word file we can insert field in between the text file

looking for response

shall i forward u the file so that it will be easy to understand the problem

I would recommend using a report for the main table and a separate sub report for each related table to pull data. Access does handle this very well. While a word merge does not handle this very well.

 

[anil_gupta2k]

Hello everyone..

I have developed a database in MS Access
Basically it contains

4 tables

1st Table -> Information
2nd Table -> Item Details
3rd Table -> Vendors Details
4th Table -> Member Details


I usually enter details in Information table and item detail tables ( basically more than 1 items are entered) than I add vendor details..The whole thing is done through form and working fine.

The whole thing is done for raising Tender Enquiry.(For which i have developed the program)

I generally generate report using word mail merge and using the table as database. Before that i had only 1 table but in this version i have four table and in mail merge we can connect only one table.

So i cannot resolve this problem...

I have tried MS Access Report but not possible ...as data is to be inserted as per our requirement.

Looking for a response

Anil

any1 having the idea