R
RickJ
I have a report that is based on a query in which two tables are related in a
one to many relationship- tblCases and tblFees. I generate a report which
contains an expression IIf([Feecheckorder]=Yes and [Feecheckwritten]=No,
"Write check payable to [Feedescription]",""). These 3 fields are from
tblFees.
I might have just one, or ten entries in tblFees that are associated with
just one case in tblCases.
The problem is that if I have more than 1 entry in tblFees associated with
the particular case in tblCases, this expression will only cause one entry
from tblFees to display on the report.
Can the above expression be rewritten or augmented so that it will display
two or more tblFees entries in the report if they meet the expressions'
criteria?
I know this can be done by the use of sorting/grouping, but for various
reasons I would prefer not to go in this direction, and would prefer to solve
the problem by modifying the above expression.
Any suggestions appreciated.
one to many relationship- tblCases and tblFees. I generate a report which
contains an expression IIf([Feecheckorder]=Yes and [Feecheckwritten]=No,
"Write check payable to [Feedescription]",""). These 3 fields are from
tblFees.
I might have just one, or ten entries in tblFees that are associated with
just one case in tblCases.
The problem is that if I have more than 1 entry in tblFees associated with
the particular case in tblCases, this expression will only cause one entry
from tblFees to display on the report.
Can the above expression be rewritten or augmented so that it will display
two or more tblFees entries in the report if they meet the expressions'
criteria?
I know this can be done by the use of sorting/grouping, but for various
reasons I would prefer not to go in this direction, and would prefer to solve
the problem by modifying the above expression.
Any suggestions appreciated.