Search results for query: *

Thanks K, How would you limit the rows being returned from the access database? This is the first time I've had an access table linked to an ODBC report, so be gentle with me please.... Also - I am interested how I would create the sql expression in access to return the year. Would I create a...

I am linking 2 ODBC tables (Providex MAS 90)with an MSAccess database. The ODBC tables had inventory sales info so Part number,units sold, year. (Multiple records per part number) The Access database has the part number, qty on hand at month end, and date. (Also mulitple records per part...

Mike - You da man! - that is exactly what I needed. Thanks to all three of you for the excellent and very timely help. Scott

Jason - good thought - I overlooked the obvious. Statzer - that worked to, thanks guys. Now - as I get into the file requirements I notice I need to pad with zereos on the left so the number always displays 11 places, so: 1234.56 needs to be displayed as 00000123456 I've used...

Working with Crystal 8.5 to create a text file export for a banking project and ran accross a challenge: I need to take the result of a currency field and format it to have an implied decimal point, for example the current result of a field is 123.45 - I need to represent as 12345. Drawing a...

Thanks a bunch all - both the right and totext functions above do exactly what I am looking for.

Actually ran into a snafu with the length formula - it requires a string. The result of the running count formula is a number - I am playing with conversion now, but this gets pretty laborious......

Ahhh.....genius. I've been trying similar work arounds, I'll try that one now..... Thank you!!!

I am creating a crystal report for export to an ascii file and need to display the record count field as a fixed 5 digits including the leading zeros - ie record one is 00001 and record 98 is 00098, etc. Can anyone help?