Cal. Field w/ Diff. Query in Report

[Aliciakic]

Kathleen,____Thank you so much for your generosity. It works great and I never would have figured it out on my own. The members of this forum are right: you have once again gone beyond what anyone could expect and have helped another lost soul. I hope that the people of Liveware know what kind of person they have working there. Thanks again.____Herbert

[Aliciakic]

Looks like I need some help again. This report that Kathleen helped me with is working great. In fact, I am using this report as a model to create a very similar report.____This new report is basically the same report as the one I describe above, this time comparing the amounts from this year^s (different) fundraising drive to the amounts from last year^s. However, the main difference is that instead of dealing with a field with just the year of a fundraising event, the table that holds the information for this fundraising drive has a date field with the date that a contribution was received.____Like the other report, I tried to set up an exact lookup relation back to the same child table. I created a calculated field with the expression RECORDID+"2006" that was used as the linking field. For the index expression (using Flexlink), I used RECORDID + STR(YEAR(SP01RECD)) with SP01RECD being the date field mentioned above. (I had first used the index expression above without the STR function, and it caused the program to crash.) Failure action is set to blank.____The last year column in this report is blank. It seems that it is not finding the matching 2006 record for the 2007 record found in my query. I can^t figure out what I am missing. Any help would be appreciated.

[kfleming]

Try:____RECORDID + TRIM(STR(YEAR(SP01RECD))) ____Kathleen__R&R Support

[ShaBoub]

Thanks for responding. Unfortunately, it does not seem to work.

[hhugh]

Does anybody have any other ideas? Thanks.

[kfleming]

If you want to send the report to me, I will see if I can fix what is going wrong.____Kathleen__R&R Support__livesupport@livewarepub.com

[mhllAtots]

10 days to write dissertation dissertation consulting service dissertation edit <a href="http://dissertationwritingxwgb.com/#">dissertation writing</a> dissertation services in uk essays http://dissertationwritingxwgb.com/

[mhllAtots]

thesis dissertation writing writing dissertation service dissertation writing <a href="http://dissertationwritingxwgb.com/#">pay someone to write my dissertation uk</a> uk dissertation writing services http://dissertationwritingxwgb.com/

[mhllAtots]

dissertation writing services custom dissertation writing service geography dissertation help <a href="http://dissertationwritingxwgb.com/#">custom written dissertation</a> best dissertation service http://dissertationwritingxwgb.com/

[mhllAtots]

editing dissertation writing dissertations undergraduate dissertation writing <a href="http://dissertationwritingxwgb.com/#">ordering dissertations</a> college custom dissertation http://dissertationwritingxwgb.com/