N
Nadine via AccessMonster.com
Hi -
Thanking anyone in advance for helping me out on this one. I might struggle
with explaining this in a manner that you can understand but here goes.
I have a query which returns at least two records. I am dealing with CLAIM
information - the first record contains the original information as the CLAIM
was paid and the second record is for the revised information as there was a
change in the information used to calculate the claim. The KEY IDENTIFIER
for my CLAIMS is the Claim Release Number. For example: The first has a
CLAIM RELEASE No of 3608-0 and the second one has a CLAIM RELEASE No of 3608-
1. *** As a note - when the report is run - the user is prompted for the
Claim Release No - I have a LEFT FUNCTION on the field in order to ensure
that both records are returned.
This query is used as the Record Source for my REPORT.
On the REPORT in the DETAIL section - there is the following information:
Insured Area 20.00
Measured Area 20.00
Total Harvest Yield 30305.00
Deficit 2437.00
Multiply by Established Price 0.3500
Amount of Claim 852.95
LESS PREVIOUSLY PAID CLAIM *** HERE IS MY PROBLEM - this value comes
from the first record (3608-0)
Total Claim Payable = [AMOUNT OF CLAIM] -
[LESS PREVIOUSLY PAID CLAIM]
All other fields in the detail section of the report (except for the LESS
PREVIOUSLY PAID CLAIM) come from the revised record - 3608-1.
Is this possible?
To have two records returned from a query but displayed as one record in the
detail section of the report?
Hope this makes sense! And let me know if there is anything else I can
provide to you so that you might be able to understand my post!
Thanks again!
Nadine
Thanking anyone in advance for helping me out on this one. I might struggle
with explaining this in a manner that you can understand but here goes.
I have a query which returns at least two records. I am dealing with CLAIM
information - the first record contains the original information as the CLAIM
was paid and the second record is for the revised information as there was a
change in the information used to calculate the claim. The KEY IDENTIFIER
for my CLAIMS is the Claim Release Number. For example: The first has a
CLAIM RELEASE No of 3608-0 and the second one has a CLAIM RELEASE No of 3608-
1. *** As a note - when the report is run - the user is prompted for the
Claim Release No - I have a LEFT FUNCTION on the field in order to ensure
that both records are returned.
This query is used as the Record Source for my REPORT.
On the REPORT in the DETAIL section - there is the following information:
Insured Area 20.00
Measured Area 20.00
Total Harvest Yield 30305.00
Deficit 2437.00
Multiply by Established Price 0.3500
Amount of Claim 852.95
LESS PREVIOUSLY PAID CLAIM *** HERE IS MY PROBLEM - this value comes
from the first record (3608-0)
Total Claim Payable = [AMOUNT OF CLAIM] -
[LESS PREVIOUSLY PAID CLAIM]
All other fields in the detail section of the report (except for the LESS
PREVIOUSLY PAID CLAIM) come from the revised record - 3608-1.
Is this possible?
To have two records returned from a query but displayed as one record in the
detail section of the report?
Hope this makes sense! And let me know if there is anything else I can
provide to you so that you might be able to understand my post!
Thanks again!
Nadine