×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

Case issue with joins

Case issue with joins

Case issue with joins

(OP)
Hello

i was trying to join two tables with the link function but am having issues with the Case's for the fields im joining on.

one is Firstname.LASTNAME@company.com and the other table has firstname.lastname@company.com (all lower case)

is there a way to ignore case and focus on the content/values

i already tried to specify Upper {table1} = Upper {table2} in the formula workshop with no success

RE: Case issue with joins

I am not sure why the upper did not work for you. Did you put each field in a formula by itself and see what kind of results you got (i.e,. Upper({emailfield}) )

RE: Case issue with joins

(OP)
hi Kray4660, I tried to do as you suggested but it came up with the error message "a Boolean is required here"

any suggestions

RE: Case issue with joins

Are you putting the formula in the record selection part of the report? Just drop the formula in the body of the report (it is just for testing to see what the upper function is returning), not trying to filter yet.

RE: Case issue with joins

(OP)
Hi yes I was putting that formula in the record selection area.
I'm not to sure how to just drop the formula in the body as you said

RE: Case issue with joins

(OP)
I did create a formula field which was uppercase({emailid)} and put it in the body and this worked

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