This content has been marked as final. Show 2 replies
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?