two fields having same value
two fields having same value
How can I generate a report for items having same value in two fields. For example, In the data base,I want to find out for which load the motor nameplate HP and the load BHP are same.
=> RE: two fields having same value
If you sort by motor nameplate HP, then BHP then load you will get a list of records in that order.____If you only want to see those records where there is more than one load with the same nameplate HP and BP you could create a total field that counts the load, make it pre-processed and then use it in a query to see only those records where the total is greater than 1.____Kathleen__R&R Support____