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

Using two fields to define a third field

P: 2
I am having a problem figuring out how to do this.
Nothing I am doing is correct :-(

I have a list of status codes (98 of them) and 3 different percentages for each of these codes...in turn a status code and percentage combo will equal a third field called "recovery source"

How do I tell a query my criteria?

I am sure that I am just missing something.

Thanks,
Cindy
Sep 6 '06 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I will assume you have a table or query that matches the status code to the relevant percentage. Go to new column in query and put:

Recovery_Source: [Status Code] * [Percentage]

I just assumed you wanted to multiply but you can do anything you want.


I am having a problem figuring out how to do this.
Nothing I am doing is correct :-(

I have a list of status codes (98 of them) and 3 different percentages for each of these codes...in turn a status code and percentage combo will equal a third field called "recovery source"

How do I tell a query my criteria?

I am sure that I am just missing something.

Thanks,
Cindy
Sep 6 '06 #2

P: 2
Thank you for your quick reply. :-)

Recovery source is totally unrelated to the two other fields, just a field that a client wanted on a report based on the values of the first two fields.

Might be clunky, but I concatenated the two fields in a query and used that as a specific field I could use to define the 3rd field.


Thanks,
Cindy
Sep 6 '06 #3

Post your reply

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