InfoPath Dev

I have a form that is connected to one table in an Access database. The fields in question are all formatted as Number fields (double) in the database.

I am doing aggregate (sum, etc) formulas via expression boxes on the fields returned. Depending on the values used to filter the data in the query section (these fields are used to select the proper group of records, no calculations are performed using these fields), I receive either a correct result in the expression box or 1.#QNAN. This would lead me to believe there is an entry in the database that is causing the issue, but I have searched the database and there are no values that might be causing the issue (no negative numbers, no zeros, etc). Is it possible InfoPath is still treating a value as a text or some similar situation?

Thanks in advance...

Travis

I would create a test view that shows all of the data or a range that is in InfoPath.

Expression boxes can be good since you can see it without formatting.

Then see is you can find the bad data. You could create a calculation field for each row that could help flush out the data field.

Thanks Clay, I will give that a try and see if I can isolate it.

Makes you feel like you are going crazy!