How to show number of matched records and % from two fields from two separate tables.

[rkpatelqlikview]

Hi,

Please help on this.

There are two fields from two separate tables but some records are matched.

Trip Number from T1 and Do_Number from T2.

I need to show the number of entry records and percentage from Trip Number in to Do_number field when i select the Number (MH46F0685).

Example:

Below are the matched records (specified by same color tick mark).

No of entries with DO_number???

No of entries with out DO_number???

Thanks in advance.

[jwjackso · Accepted solution]

You don't mention how the value MH46F0685 relates to the different tables, however to get a count of values in [Trip Number] that are in Do_Number:

=Count({<Do_Number=P([Trip Number]>}Do_Number)

A percentage would be:

=Count({<Do_Number=P([Trip Number]>}Do_Number) / Count(Total Do_Number)

[rkpatelqlikview]

Thanks Jerry,

Will try with this.

"MH46F0685" is belongs to "Number" table which is Primary Key.

[rkpatelqlikview]

Thanks Jerry. Correct answer. Many thanks for your help