Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to make calculation formula

How to make calculation formula

How to make calculation formula

I have imported data from another program (private advantage) one field will need to post Male or Female.  What I am getting is True for Male and False for Female.  How do I get True to post Male and False to post Female?

Thanks from a newbe

RE: How to make calculation formula

I'm not sure if this is what you're getting at, but try this:


yourfield = "Male", "True",
yourfield = "Female", "False"


RE: How to make calculation formula


The Case function should work here but I am not getting any output.  I think there is another item I have not put into my formula to allow the the field to show the desired content.

additional suggestions?


RE: How to make calculation formula

You might have a syntax error there.  Can you copy and paste the code in that calculation here?

RE: How to make calculation formula

Cryogen's example may be backwards.  Try this:

Case ( yourfield = "True"; "Male"; "Female" )

In plain english this says; if the existing value is "True" then change it to "Male" otherwise change it to "Female".


RE: How to make calculation formula


Oops, this might be safer:

Case (
yourfield = "True"; "Male";
yourfield = "False"; "Female";

In my previously posted formula it didn't take into account the fact that the gender may be unknown.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close