ContributionsMost RecentMost LikesSolutionsChanging a field label when printing I have a summary field that when printed I would like a different label. I think I have to do this in the formula but i don't know how to do it. ------------------------------ Lori Pelzel ------------------------------ Re: Getting a field to lookup a new valueYes I have a relationship and it works but if I go back and fill in the value that needs to be looked up it doesn't work. Getting a field to lookup a new value How can I ask a field to simply lookup the information again? ------------------------------ Lori Pelzel ------------------------------ Re: How can I add a form to a home page? Thanks for responding. I wanted to have one home page for our sales reps. I needed to make it really simple so I made a for that has only the information they would need on the road. The form is perfect - I just want that to be their home page. Thanks Lori ------------------------------ Lori Pelzel ------------------------------ How can I add a form to a home page? How can I add a form to a home page? ------------------------------ Lori Pelzel ------------------------------ Results of Formula Fields that we want to copy into field I can edit.I have a commission field that is calculated. My boss wants to be able to change the amount. How can I copy the values in that field into a field that can be edited? Thanks, Lori ------------------------------ Lori Pelzel ------------------------------ F1 keysIs it possible to have an F1 key do a specific task? For example, if you are in the system but want to pop to another screen without using the menu. Thanks, Lori ------------------------------ Lori Pelzel ------------------------------ Re: Need help with a formula that is asking for last year Thanks for the quick response, I will try it tomorrow at work. Lori Need help with a formula that is asking for last yearvar date datevariable = AdjustYear([WTF],-1); SumValues(GetRecords("{9.EX.'"& [Distributor] &"'} AND {12.EX.'"& [Manufacturer] &"'} AND {11.OAF.'"& $datevariable &"'} AND \n {11.OBF.'"& [WTF] &"'}"), 159) So this is saying sum the Year to Date value in field 159 when the Distributor and Manufacture are the same and the Date is last year. WTF is the date field I'm trying to define as last year? Something is wrong, it works perfectly when I use this for the current year-to-date total. var date datevariable = FirstDayOfYear([WTF]); SumValues(GetRecords("{9.EX.'"& [Distributor] &"'} AND {12.EX.'"& [Manufacturer] &"'} AND {11.OAF.'"& $datevariable &"'} AND \n {11.OBF.'"& [WTF] &"'}"), 159) Thanks for your help! Lori ------------------------------ Lori Pelzel ------------------------------ Re: YTD and PYTD VALUESThanks, if you ever have any thoughts (think of it in the shower) please pass them along. Much appreciated! Lori