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
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/