Can we combine 3 queries on 1 report? :?

[radicrains]

FIrst thing first, I'm truly glad that i got to knw this forum! So far the questions I've asked have receive great answers from all the forumers out there! Thank you so much for help me out on my project for internship..



Anyway, so basically, the deeper i get into the project, the more questions i have to clear my doubts and problems..

I'm creating a database that keeps track on the companys' engineer's performance. The drawings goes through 3 approval: Owner, class and production. So we basically need to know/extract information to know that either when our drawings needed to be issued or are they overdue..

So right now, I need to generate a report that requires me to generate drawings that ARE GOING TO DUE in the nxt 14days..
Previously I did the basic application on queries. I had extracted all drawing information on Owner,class and production INDIVIDUALLY then I added in:

Criteria: Between [EnterDate] and DateAdd("d",14,[EnterDate]) in the DateToClass field
& Criteria: Is Null in the LatestRevDate field

*Refer to attach Picture for a clear understand*


So basically, by doing the above methods, I have to repeat it to obtain 3 sets of queries. However, when I've combined the 3 results together to get the summary of all three, there isn't any output in the outcome of the report..

I don't understand why, but is it because I'm not suppose to combine 3 queries into 1 report? If yes, then is there a way for me to combine all these information in 1 query?

thanks in advance..

[NTC]

one can have 3 subreports in a report - as one technique.

to merge the queries itself is a different issue and would depend on how those join and cross reference together.

[radicrains]

one can have 3 subreports in a report - as one technique..

I've tried to do a subreport, but it's a lil impossible because let's say i have over 400 drawings that are overdue, I can't put them all together..

to merge the queries itself is a different issue and would depend on how those join and cross reference together..

Is there a way to make it possible? I tried to create a function using VBA that help works, but I dont know how to input the function for "parameter" inside the module..

[radicrains]

Here's the function that I've created, Please correct me and show me how to insert a box that prompt me for "EnterDate"(usually assume as System date).. I'm still new, please guide me.. thanks

Function GoingOverdue (ParamArray FieldArray() as Variant)

Dim N As Variant

N = Null

If FieldArray(0) = Date() and FieldArray(1) = "" Then
N= FieldArray(0)
End If

GoingOverdue = N

EndFunction