jeremie_ingram
Registered User.
- Local time
- Today, 02:16
- Joined
- Jan 30, 2003
- Messages
- 437
I know there are a few topics on this, but none I have found hit the nail on the head.
Synopsis: I have two separate systems containing measurements for the same items. A good percentage of them are right on the money in the measurements, but some are way off base.
The structure:
tblClass
-class*
jcttblClassToPin
-class*
-pin*
tbl1
-pin*
-1sqft
tbl2
-pin*
-2sqft
I have created queries that calculate the differences with the formula 2spft/1sqft. In this query I run a count on the pin and group by class. I then add the criteria for the percentage "Not Between .99 and 1.01" (for 1%). This returns a count for each class that have a difference of values over 1%.
My problem is that when I go to 50% not all classes are represented. Out of the 17 possible only 9 are showing up.
I would like to have all classes appear in the report even if there is no return value in the query.
The way it is now
1 % 10% 50%
Class A 230 Class A 10 Class A 2
Class R 150 Class R 110 Class T 80
Class T 250 Class T 100
Each percentage is its own sub report. As shown above, class R disappears in the 50% area because there was nothing returned for it in that reports query. Is there an easy way to get this to display a count of 0 in the report so that they all line up nicely?
Synopsis: I have two separate systems containing measurements for the same items. A good percentage of them are right on the money in the measurements, but some are way off base.
The structure:
tblClass
-class*
jcttblClassToPin
-class*
-pin*
tbl1
-pin*
-1sqft
tbl2
-pin*
-2sqft
I have created queries that calculate the differences with the formula 2spft/1sqft. In this query I run a count on the pin and group by class. I then add the criteria for the percentage "Not Between .99 and 1.01" (for 1%). This returns a count for each class that have a difference of values over 1%.
My problem is that when I go to 50% not all classes are represented. Out of the 17 possible only 9 are showing up.
I would like to have all classes appear in the report even if there is no return value in the query.
The way it is now
1 % 10% 50%
Class A 230 Class A 10 Class A 2
Class R 150 Class R 110 Class T 80
Class T 250 Class T 100
Each percentage is its own sub report. As shown above, class R disappears in the 50% area because there was nothing returned for it in that reports query. Is there an easy way to get this to display a count of 0 in the report so that they all line up nicely?
