-
Hi! So, what are your options for this Access DB? Because personally I'd start with two tables - one to store my header info, then another to store the repeating data. I think you can modify your database, then walk through the main connection again to update it - and then you'd be able to add the header table and the connected ...
-
Oh great - so that error - for some reason, InfoPath thinks you've bound that calc'd value to repeating data (even though you have a filter on it and know it will only return one item!). I've generally only had a problem with it if my form has code and is directly published to a form library (sandboxed) or if my form is admin approved ...
-
Do you have code in the form?
-
But when you preview the form, is the count correct? Because your formula looks right to me. Or were you just concerned you'd have issues when you publish? As long as your form doesn't have code, that error can be ignored - here's a blog post about it. ...
-
Fantastic, glad you have it working!
-
Yeah, I think you could do this in InfoPath - add two data connections, one for each list. Then use the repeating data source node for the Reviewer List for the table on your form.... The count formula will be a calculated value that adds up the counts all instances of Reviewer1, 2, or 3 that match the reviewer in the given row.... Then you ...
-
Do you not want the event to = 1? Sorry, thought that was part of your original description of what you wanted. What does "seems to go into a loop" mean? Here is a version w/out the Event = 1 in the field2 count formula.
-
I usually open task manager and go to the processes tab. I make sure the show processes for all users checkbox is selected, then look for InfoPath.exe and end it via task manager.
-
Give this one a try - I changed your formula in field2 to count (hopefully!) all rows where Event = 1 and the date range is in the selected start / end date....
-
Also make sure Windows updates have been installed for Office 2013 - it could be something there....