Page 1 of 1
two fields having same value
Posted: Fri Dec 02, 2005 1:15 pm
by savdhatn1
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
Posted: Sun Dec 04, 2005 10:41 am
by kfleming
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____