Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: count in more than one table

    Many thanks,

    but the problem is that the result for NumberOfSales is Count(SalesOld.SalesManID)*Count(SalesNew.SalesManID)*2.

    For example one salesman has 35 entries in SalesNew and 334 in SalesOld.

    The result of the Count(SalesOld.SalesManID)+Count(SalesNew.SalesManID) is 35*334*2=23380

    CU

    Thorsten

    February 6, 2013 at 10:01 am

    #1585041

Viewing post 1 (of 1 total)