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.


Compare Value of Field to Any Value in Another Field

Compare Value of Field to Any Value in Another Field

I'm trying to match the value of a field in 'Column A' to any row of data in 'Column B', not just the fields corresponding row.

Column A Column B Match?
1 6 Yes - "1" matches in row2
2 1 No - no match for 2
3 7 No- no match for 3
4 4 Yes- "4" matches in row4

RE: Compare Value of Field to Any Value in Another Field

What relates the 4 rows?
You will need to group on that and then use variables to capture value of col A and compare with values in ColB

If you can't do that then you will need to use a subreport and pass a shared variable from Col A and look for data in col B in subreport


RE: Compare Value of Field to Any Value in Another Field

How will you use this information? Why are you checking for a match? If you just want to be able to detect a match, you can insert a crosstab in the report header or report footer, and then add columnA as the row and columnB as the column. Then create a formula like this:

if columnA = columnB then 1 else 0

Use this as the summary field, and use a maximum as the summary.


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!


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