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));

Sign In or Register to comment.