Number too large for crystal

[APB1981]

Hello I have a very complex problem I need help with.
I need to sort the order of transactions in my database but many transactions have the exact same transaction date. There is also a unique timestamp field but I can not use this alone as a user can specifiy the transaction date manually and timestamp number will always be based on today. I want to join these 2 fields together somehow and group the material that way. The only problem is this generates a number too large for crystal: 2.01e+026
yyyymmddhhmmss&1234567891
and the summaries can not pick up the correct miniumum date and maximum date.

Any ideas.

Crystal R2
MSSQL 2005

Thanks

APB

 

[IanWaterman]

How are you joining, your same number is not that big. Looks like your concatenation process is doing something wrong.

Please show formula with sample data before you concatenate.

Ian