Since I'm using a form with PDF artwork and can't use tables or subforms I need to find a way to count the number of weeks based on the number of non-null date fields. Anyone know how to do this? When I use count (Weeks[*]) I get the right number of weeks but I also get Error arithmetic over/underfl...

Possibly. The challenge I'm haing stems, I think, from working on a form with PDF artwork so I can't create a Table or a subform, meaning all the calculations have to be done manually and that I am comparing two calculated sums. Ihad been thinking I could use an if expression but couldn't figure it ...

I have a form which sums numeric data (amounts) in both columns and rows. I need to verify that the sum of the row of totals and the sum of the column of weekly totals are identical and dsiplay the total in a single grand total field. Because the form was imported as a fixed field form Tables and Su...