I'm experiencing serious problems with access reports. The problem I'm currently facing:
I have 2 crosstab queries:
qryCost:
FacilityName Date1 Date2 Date3.....Date24
Building1 Cost Cost Cost......Cost
Building2 Cost Cost Cost......Cost
qryUsage:
FacilityName Date1 Date2 Date3.....Date24
Building1 Usage Usage Usage.....Usage
Building2 Usage Usage Usage.....Usage
I created a report based on qryCost. This report works fine. It looks exactly like the query. The problem occurs when I try to add in qryUsage. I want to the final report to look like:
FacilityName Date1 Date2 Date3.....Date24
Building1 Cost Cost Cost......Cost
Building1 Usage Usage Usage.....Usage
Building2 Cost Cost Cost......Cost
Building2 Usage Usage Usage.....Usage
I tried to make a subreport and I got a result that looked like this:
FacilityName Date1 Date2 Date3.....Date24
Building1 Usage Usage Usage.....Usage
Building1 Cost Cost Cost......Cost
Building2 Cost Cost Cost......Cost
Building3 Cost Cost Cost......Cost
Building4 Cost Cost Cost......Cost
Building5 Cost Cost Cost......Cost
Building6 Cost Cost Cost......Cost
Building1 Usage Usage Usage.....Usage
Building1 Cost Cost Cost......Cost
Building2 Cost Cost Cost......Cost
Building3 Cost Cost Cost......Cost
Building4 Cost Cost Cost......Cost
Building5 Cost Cost Cost......Cost
Building6 Cost Cost Cost......Cost
and so on... Can some one please help me figure out what to do?? I really would appreciate any help you could provide. I've never worked with reports and am very confused.
Note: I have another post about a similar topic but they are different. I'm not reposting the same quesiton. Thanks for you help.
I have 2 crosstab queries:
qryCost:
FacilityName Date1 Date2 Date3.....Date24
Building1 Cost Cost Cost......Cost
Building2 Cost Cost Cost......Cost
qryUsage:
FacilityName Date1 Date2 Date3.....Date24
Building1 Usage Usage Usage.....Usage
Building2 Usage Usage Usage.....Usage
I created a report based on qryCost. This report works fine. It looks exactly like the query. The problem occurs when I try to add in qryUsage. I want to the final report to look like:
FacilityName Date1 Date2 Date3.....Date24
Building1 Cost Cost Cost......Cost
Building1 Usage Usage Usage.....Usage
Building2 Cost Cost Cost......Cost
Building2 Usage Usage Usage.....Usage
I tried to make a subreport and I got a result that looked like this:
FacilityName Date1 Date2 Date3.....Date24
Building1 Usage Usage Usage.....Usage
Building1 Cost Cost Cost......Cost
Building2 Cost Cost Cost......Cost
Building3 Cost Cost Cost......Cost
Building4 Cost Cost Cost......Cost
Building5 Cost Cost Cost......Cost
Building6 Cost Cost Cost......Cost
Building1 Usage Usage Usage.....Usage
Building1 Cost Cost Cost......Cost
Building2 Cost Cost Cost......Cost
Building3 Cost Cost Cost......Cost
Building4 Cost Cost Cost......Cost
Building5 Cost Cost Cost......Cost
Building6 Cost Cost Cost......Cost
and so on... Can some one please help me figure out what to do?? I really would appreciate any help you could provide. I've never worked with reports and am very confused.
Note: I have another post about a similar topic but they are different. I'm not reposting the same quesiton. Thanks for you help.
