Recent content by mtriolo

Thanks for the reply - the VBA formula that you gave me do you create this in the modules? I will try thanks again for the help

Hi I am trying to create a formula that will update a field in my table - I have created an update query and want to update the field GPA. I have tried using the iif formula without success. Here is what I want to calculate. I have two fields one is Score the other is Baseline. The formula...

Thanks it does work.

I have a form that when I click on the print button it goes to a report. From there I can export out to snapshot or word. Most of my staff does not have snapshot but they all have adobe reader. I have no option to export file to adobe reader. Does anyone know how to add this option to...

Thanks for the help - The report works.

The formula worked - thank you. I am trying to learn what expression is best used in a particular calculation. I do have one additional error - I have set up a total field in the report footer and I would like to sum up the numbers in that column but I am getting a negative number(-91) when it...

I am having a problem in getting the correct formula to calculate the number of reinspections in a report. What I need is to calculate the number of reinspections in two separate fields. This report is tied to a query that has Date of Reinspection, Reinspections(number of reinspections)...