LauraLinssen1
4 years agoQrew Trainee
Formula Queries or some other way to do this.....
What am I trying to do..... I have Sales Reps that can have multiple incentive programs that are based on an Effective Date and an End Date. I have a different table that is calculating their Actuals vs. Objectives, however, I need the correct data for a month that coincides with the active incentive program record at that time.
I was thinking of using a formula query to look at the records in the table for the one that matches the related person and where the date of the month in question falls in between the Effective Date and the End Date. But I don't just need the Record ID of what is found, or a listing of records. I want the value in the field that I am looking for.
So long story short, I need help to say, hey for this value, which program value do I need to go with.
------------------------------
Laura Linssen
llinssen@jjkeller.com
------------------------------
I was thinking of using a formula query to look at the records in the table for the one that matches the related person and where the date of the month in question falls in between the Effective Date and the End Date. But I don't just need the Record ID of what is found, or a listing of records. I want the value in the field that I am looking for.
So long story short, I need help to say, hey for this value, which program value do I need to go with.
------------------------------
Laura Linssen
llinssen@jjkeller.com
------------------------------