Getting value of 3rd col when we enter first two col values

15 pts.
Tags:
Database programming
I hv data base with 3 cols. i want to wrte a formulae like when ever i giv two values the third value should automatically come

Answer Wiki

Thanks. We'll let you know when a new response is added.

Could you be more specific? What program, language, etc.?

-Schmidtw

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Swapnilsurve
    Please provide more details about the specific database and version. Different applications perform calculations in a different manner.
    0 pointsBadges:
    report
  • Swapnilsurve
    The data base is as folllows A B C Branch Dept Code Mum it 141 Mum acc 142 Mum cdg 143 Del it 144 Del acc 145 Del cdg 146...... Like this the master data base contains this details In a new sheet I want a formula that will automatically give me Code when i put Branch & Dept.
    15 pointsBadges:
    report
  • SbElectric
    This is not really a database - rather a listing of items. How do you ensure that for same Dept and Branch there is not more than one Code? Need to define tables and their relationship. If it is just plain data then you may be better off to use Excel. Just an observation - may be I missd your point.
    2,540 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following