2 Replies Latest reply: Jan 11, 2013 4:13 AM by mrpjspencer RSS

    Problem with Nulls again!

      Hello, on the billing database  I work with I have a problem reporting on if 2 payments come in on at the same time/day. For example

       

      [Customer Number][ Paid amount][Date]               [Type]

      1150                        £54               01/04/2012          -

      1150                        £67               01/04/2013          -

       

      On the Database each line item does have a type value but because all of the data is the same in the report, it chooses to make it a null when this isnt right.

       

      Ive Tried Firstsortedvalue( DISTINCT [Type],-[Date] ) but this doesnt work.

       

      Any ideas Please?

       

      Paul.