Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using concatenation to create the data I need, but pre concatenation I have the records I need to get the final figure, but when I use concatenation, some of my records are missing giving me different totals. When I add a field I then get the totals I need. Although the field I add is not a key field. Can any one help or has anyone experienced this?
regards
M
My Solution to this was to use group by rather than distinct as swehl suggested. the distinct is using the distinct records from the unshipped table and then concatenating the records on to that table which then does a distinct hence losing the records that I need.
Thank you for all your help.
regards
M