MS Access Math problem?
I have 3 variables that I know. I need to find out the missed % for each line by using the 100% format. I need it for a query.
Session--Total Missed------# Days Active
42-------29----------------51
86-------0-----------------59
35-------4-----------------118
16-------5-----------------444
Comments
I'm not sure which of the two variables is relevant here so I'll assume that you want to know [Total Missed] as a percentage of Session.
Create a MS query using the table that includes your data. In one of the columns, instead of dragging one of the fields from the table, enter the formula ([Total Missed]/Session). You need the brackets because "Total Missed" contains a space. Be sure to add a condition so you aren't dividing by 0.
Access will name the column Expr1:([Total Missed]/Session)
If you look at the query using the SQL view, it will look something like this:
SELECT ([Total Missed]/Session) AS Expr1
FROM [Table Name]
WHERE ((([Table Name].Session)>0));