I have a time field in an Access table that I can't format
as a time field in CR.  It always shows up as 99/99/99.
Anybody know how to get around this??

Thanks in advance...

Kelton

The obvious way to me would be to change your date/time field to a text
field, then format it to look like a date or time (ie:
format(yourvariable, HH-MM AMPM), etc,etc.  this works for either time
or dates.

The only down side to this is that if you need to use the date/time
field in a sort, then it won't work.  I have gotten around this by using
formula fields to convert it back to date, which is kind of a pain in
the ass, but it does work.  

Check out crystal's web site, they have a pretty decent knowledge base
for this, and if you have a question, they will email you back in a day
or two (crystalinc.com)

I really haven't quite figured crystal out yet.  It seems that
everything you need to do has to be done differently than you would
expect.  But I have'nt found anything yet that can't be done.

Good luck!