Looking for Microsoft Access and InfoPath experts.

I thought I mentioned that I tried doing that, it doesn't work. If you take a formula like the one in the screenshot and try inputting it into the table instead of the form you'll get an error saying something along the lines of "invalid field name". According to the Microsoft help page this is a normal error so the only work around is to use a form.