I have a query that counts how man records match a certain criteria and what I want to do is have the query request a user to input a number value (how many people are at the company, which changes week by week) and then calculate that number to get a percentage. I have the count part but I cant figure out how to get query to request user input to input the number from the company into the equation. Is this even possible if not is there another way with forms that this can be done?
Something like this:
Expr1: [TotalEnrollmentsCountQRY]![CountOfLast Name, First Name]/[Request user input for a number]
User inputs 347
Expr1: [TotalEnrollmentsCountQRY]![CountOfLast Name, First Name]/[347]