I did a infopath form connecting to submit both information to Access and Sharepoint(for workflow approve). Everything is great, almost completed, but when I am trying to use "Run Query", a field in the repeating section does not return correct value, only 0.
This field has a formula which help the user to calculate the value from input data in the same repeating table when the user fill-in the infopath. It works correct when user fill-in the data, but if the user try to run query, and get existing data from Access datasource, this formula just return 0.
Anyone can help me on it?