https://www.infopathdev.com:443/forums/43.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/105748.aspxTue, 08 Mar 2016 23:42:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105748Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/105748.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=105748I'd think as a default in Temp_Vac: ../preceding-sibling::d:Vacation_Info[1]/@Used_Vac_Hrshttps://www.infopathdev.com:443/forums/thread/105747.aspxTue, 08 Mar 2016 23:34:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105747iengineer860https://www.infopathdev.com:443/forums/thread/105747.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=105747Yes i am putting in temp_vac as default. My goal is to use the previous value from used_vac_hrs so that in the access databae i can store the total hours used and then can subtract from the total to show the remaining hourshttps://www.infopathdev.com:443/forums/thread/105719.aspxTue, 08 Mar 2016 15:47:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105719Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/105719.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=105719Where are you putting this formula? In Temp_Vac as a default?https://www.infopathdev.com:443/forums/thread/105705.aspxSun, 06 Mar 2016 15:26:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105705iengineer860https://www.infopathdev.com:443/forums/thread/105705.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=105705Hi Guys, I have two tables in access database Employee Info(Parent) and Vacation Info(child). With in vacation info I have 2 fields Used_Vac_Hrs and Temp_Vac ------------------------------------ I want to copy the previous row value of Used_Vac_Hrs into Temp_Vac field . ----------------------------- I tried formula like : " preceding-sibling::Vacation_Info[1]/Used_Vac_Hrs " ------------------- " ../preceding-sibling::dfs:dataFields/d:Employee_Info/d:Vacation_Info[1]/@Used_Vac_Hrs " ---------------------- nothing is working for me . All shows error message " does not point to a valid location path of a field or group" -------------------------- Xpath for Field Used_Vac_Hrs is : /dfs:myFields/dfs:dataFields/d:Employee_Info/d:Vacation_Info/@Used_Vac_Hrs" --------------------------------------------------- Xpath for Field Temp_Vac is : /dfs:myFields/dfs:dataFields/d:Employee_Info/d:Vacation_Info/@Temp_Vac" ----------------------------------- I also attached the screen shot for hierarchy of my fields . Please help... note: I am creating this form on shared network drive NO sharepoint etc. THANK YOU Friends..