Hi All,
I am writing a report that will eventually show our salespeoples’ hit/miss ratio for converting samples sent to a customer into real production orders. Currently, this is a two query report. The first query will return all part codes from sample orders that also have production orders, the second query returns only part codes from sample orders.
My problem is this: I need one column to show only the results from query 1, and another column to show only the results from query two. The kicker is that this is the same object from query 1 and query two “part code.” B.O. links these by default, which is not good for my purposes. I get the combined results for both queries. If I unlink the query, B.O. will not let me insert the second object.
Eventually what I want to do is compare query one and query two, if they match then return 1, if they don’t because the second column is null, then return 0. Then I can do a ratio of 1’s to 0’s and return and give management the info they want.
Any ideas appreciated.
thanks
jim
deliverator (BOB member since 2003-10-28)