By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,028 Members | 1,309 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,028 IT Pros & Developers. It's quick & easy.

Form based calculation involving query results

P: 11
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.
Apr 8 '08 #1
Share this Question
Share on Google+
3 Replies


MindBender77
100+
P: 234
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.
To answer your question: Yes, this is very possible.
You could have four unbound textboxes on a form for the goal. Another for the result of your other query. A final textbox for the end result.

After the one of the four goals has been entered, an Append query could add data to a temp table using criteria from the goals. A dlookup function could then be called to populate the next textbox. Finally, the last textbox could then be automatically populated with the end result.

The temp table would be purged on the Form Close event.

Hope this points you in the right direction,
Bender
Apr 8 '08 #2

missinglinq
Expert 2.5K+
P: 3,532
Please remember to provide a meaningful Title for any threads you start! This helps to ensure that other members, and also the general public, will have a better chance of finding answers to similar questions. It is difficult for the experts to answer questions when there is not enough details provided to understand the problem.

Please take the time to read the Posting Guidelines, paying particular attention to Give a clear title to your question.

Thank you and Welcome to bytes!

Linq ;0)>
Apr 8 '08 #3

P: 11
Thank you for your help! I really appreciate it.

And I will make sure my Form Posts have clearer titles. I do apologize.

Thanks guys! (and gals if applicable)
Apr 16 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.