I don't even think this is possible, but I wanted to make sure before I told my boss we need another solution.
Essentially he wants to do a Query by Form.
He would like to be able to type the goal into one of 4 fields, and then multiply what he types into the field by the result of another query.
Essentially it looks like this:
Forms!goal!txtRR*PTO![% of Max]
the % of Max is the result of another query.
Is this even possible? I know I can SEARCH for things based on text boxes in a form, but can you have a function based on data input into a form?
If not I'll try to find another solution but this is the way he would like to do it.
Thanks so much. You guys are always so helpful.