Hi,
I'm SO close, but I have a problem with a crosstab/cartesian product query that I based on Duane Hookum's example. Here's what I have:
TRANSFORM sum(iif([Fldname]="Balance",[Balance],[Return])) AS TheVal
SELECT rptBF_Custom5.PolicyNumber, rptBF_Custom5.IAName, rptBF_Custom5.TPMName
FROM...