Bringing Together 2 unrelated queries

[Guest]

What is the best way to bring together 2 unrelated queries based on different tables into one report. I can combine the queries but then I get duplicate values in fields such as consultant and date fields.

I would like to be able to have the report provide totals based on a date field for both queries. I could introduce this same field into both queries if needed.

I have both reports working independently currently but would like all infomation on one report.

I am using IF and sum statements in the one main table. The second table/query has the following fields
Location Servicing Division - Text Box
Assigned Consultant - Text Box
Month/Year - Date Field
Staff Meeting/Training - Number field such as 1.75
Vacation/Sick - Number Field such as 1.75
Special Project - Number field such as 1.75

The top 2 fields are also in the other table/query. Date field in other table is Date Written Report Sent

Best way to proceed? I can provide additional information as needed.

 

[Larry Linson]

What is it that detemines which records you want from each table in the
report?

Given that there are some common fields, I wouldn't exactly call them
"unrelated". You can put the separate reports into two subreport controls on
one report if you'd like. But, if the information is, in fact, unrelated,
what is the purpose of combining it into one report?

Larry Linson
Microsoft Access MVP

What is the best way to bring together 2 unrelated queries based on

different tables into one report. I can combine the queries but then I get
duplicate values in fields such as consultant and date fields.

I would like to be able to have the report provide totals based on a date

field for both queries. I could introduce this same field into both queries
if needed.

I have both reports working independently currently but would like all infomation on one report.

I am using IF and sum statements in the one main table. The second

table/query has the following fields

Location Servicing Division - Text Box
Assigned Consultant - Text Box
Month/Year - Date Field
Staff Meeting/Training - Number field such as 1.75
Vacation/Sick - Number Field such as 1.75
Special Project - Number field such as 1.75

The top 2 fields are also in the other table/query. Date field in other

table is Date Written Report Sent

 

[Guest]

This is a management level report that we used to do manually and now want to create it in our new Access Database. The information need to be sorted by Office and then consultant and then the particular month as this is a monthly report.

I have to use 2 seperate forms to obtain the inforamtion for this monthly report which I why the subreport control idea might be good.

Can you explain the subreport controls more. Might I be able to view the 2 subreports by the sorting I am looking for? Is that probably the easiest method. I would have no problem with using subreport controls to get what I am looking for.

Need more info, please.

 

[Larry Linson]

A subreport control is a control into which you can embed a report. If you
wish to coordinate the display in the subreport with some fields on the main
report, the subreport has LinkMasterFields and LinkChildFields properties
for that purpose. Help or a good self-study would be a good source for more,
or the training materials at the Access Online site that is linked from
Access 2003 Help -- a good starting point is
http://office.microsoft.com/home/default.aspx?Origin=EC010227011033&CTT=2.

Larry Linson
Microsoft Access MVP

This is a management level report that we used to do manually and now want

to create it in our new Access Database. The information need to be sorted
by Office and then consultant and then the particular month as this is a
monthly report.

I have to use 2 seperate forms to obtain the inforamtion for this monthly

report which I why the subreport control idea might be good.

Can you explain the subreport controls more. Might I be able to view the

2 subreports by the sorting I am looking for? Is that probably the easiest
method. I would have no problem with using subreport controls to get what I
am looking for.