Recent content by JJtwin

I did tried Msaccess Rookies solution, unfortunately it didn't work. The table still shows "#deleted' in all columns fields. I can work around with it by clicking on remove filter/sort every time I opened the table. I check table properties, and there is no filter there. Don't understand...

Thanks for the reply. I did try to drop the existing ODBC and create a new one. Then link the table to that new ODBC, but not working. Hope it works your way.

I was trying to open an ODBC linked table, but find "#Deleted' in all field columns. It only happens in my laptop. And it happens after Data adminstrator helps me to add additonal primary key to the table. Any ideas how to fix it ? Thanks

I need to extract date portion from timestamp for my crystal report. Timestamp format is '2009-10-22-13.45.34.164874.', and my desired results should be 2009-10-22. Thanks :o

the data passing is a number. For example 3000 seconds , it passed as 3000

I need help in setting up a formula to convert seconds to hour, minutes and second in the following format: HH:MM:SS Thanks

Hi, I am new to Crystal reporting. I need to produce a Monthly report, and I am using special field "DataDate and customize it to show Month and Year. But my report date needs to show previous month instead of current month. For example, if i run the report today, it should have show April 2008...