Dinner was great, and yes ssanfu, there was wine with that.
I also looked at db - a bit confusing as to what's going on when there's a lot of similarity. Anyway, I did monkey with a report but not sure what fields to base any trial on. I chose to modify the rightmost one (forget what it was called) and bind it to a new field in the query. That field calculates the fraction by using the numerator and denominator fields. There's nothing cumulative about this field IMHO but that's what the label says. So should that field look like this?
If yes, then the query sql is
Code:
SELECT tbl_ProjectNumberName.ID AS tbl_ProjectNumberName_ID, tbl_ProjectNumberName.ProjectNumber,
tbl_ProjectNumberName.ProjectName, tbl_ProjectDimNbr.ID AS tbl_ProjectDimNbr_ID, tbl_ProjectDimNbr.[Project Number Link],
tbl_ProjectDimNbr.[Dimension Nbr], tbl_ProjectDimNbr.Feet, tbl_ProjectDimNbr.Inches, tbl_ProjectDimNbr.Numerator,
tbl_ProjectDimNbr.Denominator, IIf([Denominator]>0,1,0) AS DenominatorNbr, IIf([Numerator]>0,1,0) AS NumeratorNbr,
IIf(([NumeratorNbr]+[DenominatorNbr])>1,[Numerator]/[Denominator],0) AS FractionCAL, [Feet]*12 AS FeetInches,
[FeetInches]+[Inches]+[FractionCAL] AS DimensionInches, testlcd([numerator],[denominator]) AS CumulFraction
FROM tbl_ProjectNumberName INNER JOIN tbl_ProjectDimNbr ON tbl_ProjectNumberName.ProjectNumber = tbl_ProjectDimNbr.[Project Number Link]
ORDER BY tbl_ProjectNumberName.ProjectNumber, tbl_ProjectDimNbr.[Dimension Nbr];
and the code in module1 is what I posted earlier
Code:
Public Function testLCD(intTop As Integer, intBtm As Integer) As String
If Not Nz(intTop, 0) = 0 Then
If intTop Mod 2 = 0 Then
Do While intTop Mod 2 = 0
intTop = intTop / 2
intBtm = intBtm / 2
Loop
End If
End If
testLCD = intTop & "/" & intBtm
End Function
If that's not correct, I guess I don't understand exactly what is wanted.