Cal. Field w/ Diff. Query in Report

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Aliciakic
Posts: 0
Joined: Mon Apr 30, 2018 1:55 pm

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

Post by Aliciakic » Thu Dec 21, 2006 5:11 pm

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
Posts: 0
Joined: Mon Apr 30, 2018 1:55 pm

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

Post by Aliciakic » Sun May 20, 2007 6:56 pm

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
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

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

Post by kfleming » Mon May 21, 2007 8:11 pm

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

ShaBoub
Posts: 0
Joined: Mon Apr 30, 2018 11:32 am

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

Post by ShaBoub » Wed May 23, 2007 12:21 am

Thanks for responding. Unfortunately, it does not seem to work.
Will Amoxicillin Heal Tooth Abscess Vet Keflex cialis for sale Antiphospholipid Syndrome Amoxicillin Cialis Soft Tabs De Amoxicillin Clav Side Affects

hhugh
Posts: 4
Joined: Tue Oct 10, 2017 12:44 pm

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

Post by hhugh » Thu May 24, 2007 5:45 pm

Does anybody have any other ideas? Thanks.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

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

Post by kfleming » Fri May 25, 2007 8:48 am

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
Posts: 9
Joined: Mon Aug 19, 2019 3:39 am
Location: Yako
Contact:

mnybexpivekylus

Post by mhllAtots » Mon Aug 19, 2019 3:44 am

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/
dissertation help do my dissertation me online dissertation <a href="http://dissertationwritingxwgb.com/#">abstract dissertation</a> writing dissertation http://dissertationwritingxwgb.com/

mhllAtots
Posts: 9
Joined: Mon Aug 19, 2019 3:39 am
Location: Yako
Contact:

mnybexpiveduvst

Post by mhllAtots » Mon Aug 19, 2019 3:45 am

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/
dissertation help do my dissertation me online dissertation <a href="http://dissertationwritingxwgb.com/#">abstract dissertation</a> writing dissertation http://dissertationwritingxwgb.com/

mhllAtots
Posts: 9
Joined: Mon Aug 19, 2019 3:39 am
Location: Yako
Contact:

mnybexpivefvhfo

Post by mhllAtots » Tue Aug 20, 2019 10:11 pm

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/
dissertation help do my dissertation me online dissertation <a href="http://dissertationwritingxwgb.com/#">abstract dissertation</a> writing dissertation http://dissertationwritingxwgb.com/

mhllAtots
Posts: 9
Joined: Mon Aug 19, 2019 3:39 am
Location: Yako
Contact:

mnybexpivehzxzi

Post by mhllAtots » Tue Aug 20, 2019 10:11 pm

editing dissertation writing dissertations undergraduate dissertation writing <a href="http://dissertationwritingxwgb.com/#">ordering dissertations</a> college custom dissertation http://dissertationwritingxwgb.com/
dissertation help do my dissertation me online dissertation <a href="http://dissertationwritingxwgb.com/#">abstract dissertation</a> writing dissertation http://dissertationwritingxwgb.com/

Post Reply