Page 2 of 3

==========> RE: Cal. Field w/ Diff. Query

Posted: Thu Dec 21, 2006 5:11 pm
by 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

==========> RE: Cal. Field w/ Diff. Query

Posted: Sun May 20, 2007 6:56 pm
by 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.

===========> RE: Cal. Field w/ Diff. Query

Posted: Mon May 21, 2007 8:11 pm
by kfleming
Try:____RECORDID + TRIM(STR(YEAR(SP01RECD))) ____Kathleen__R&R Support

============> RE: Cal. Field w/ Diff. Query

Posted: Wed May 23, 2007 12:21 am
by ShaBoub
Thanks for responding. Unfortunately, it does not seem to work.

============> RE: Cal. Field w/ Diff. Query

Posted: Thu May 24, 2007 5:45 pm
by hhugh
Does anybody have any other ideas? Thanks.

=============> RE: Cal. Field w/ Diff. Query

Posted: Fri May 25, 2007 8:48 am
by 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

mnybexpivekylus

Posted: Mon Aug 19, 2019 3:44 am
by 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/

mnybexpiveduvst

Posted: Mon Aug 19, 2019 3:45 am
by 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/

mnybexpivefvhfo

Posted: Tue Aug 20, 2019 10:11 pm
by 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/

mnybexpivehzxzi

Posted: Tue Aug 20, 2019 10:11 pm
by mhllAtots
editing dissertation writing dissertations undergraduate dissertation writing <a href="http://dissertationwritingxwgb.com/#">ordering dissertations</a> college custom dissertation http://dissertationwritingxwgb.com/