Access Time Fields not printing 1

[VB400]

Using Crystal Reports that comes with VB6, how do I print the Time portion from a date/time field that exists in an Access97 table?

I have an Access97 table that has a Date/Time field with a format of "Medium Time". When I created a report over this table, it prints 12/30/99 and not the time 8:15 AM.


Tarek

The more I learn, the more I need to learn!

 

[kenhamady]

Crystal has a setting that will convert the datetime to date automatically.

Check under File-Report Options.
This will change the report you have open.

To change any new report you create use the global options under File - Options - Reporting Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[VB400]

Thanks Ken, that did the trick!


Tarek

The more I learn, the more I need to learn!