Help with query formula (1 Viewer)

Purdue15

Registered User.
Local time
Today, 05:40
Joined
Jun 12, 2013
Messages
29
I have a form that has two columns one column contains criteria that is correct and is bound to a table so it auto fills, and the other column is unbound for filling in criteria that is different. Some criteria is letters others are numbers. Each column has its own table that it is sent to correct_add and new_add. My objective is to be able to fill in 100 form entries and calculate the percentages that each criteria was off. For example, if i was looking at weight criteria and correct column had 50 but I had 49 I would fill that in to the new column. I would then like to run a query that would display .02 off and so on for the other criteria. I am unsure on how to do this, I have made formulas in queries but they all seem to have errors.

I would appreciate any help!
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 05:40
Joined
Aug 30, 2003
Messages
36,118
Something like:

(Column1 - Column2) / Column1
 

Purdue15

Registered User.
Local time
Today, 05:40
Joined
Jun 12, 2013
Messages
29
Thats what I have been doing but for some reason there is always an error
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 05:40
Joined
Aug 30, 2003
Messages
36,118
It would help if you posted exactly what you're trying, and what the error is. Offhand, that would error if the divisor was 0.
 

Users who are viewing this thread

Top Bottom