Recent content by meridklt

My problem is resolved as I found rummaging around in MySQL I could in Search do a Find -- and Replace with 2019-06-08

Thanks Colin. I feel such a fool as my grandad's program has nothing to do with Access as its just MySQL with php for the web site and I will try the MySQL forum after trying out your MySQL suggestion if I can figure it out. So I'm sorry for wasting everyone's time.

I mistakenly did not enter a date into thousands of records and so now in MySQL they display those dates as -- There is an option on the web site php page to remove all dates records by entering just the year, but it does not delete them if I enter -- Can anyone help please? My grandad is...

Thanks to you all for responding to my question. It's been enlightening and it looks like I'm going to have to stay with Excel to complete my task.

I'm using Access 2000 and trying to make a data type Time Field of 12:01:02.23 Unlike Excel which lets you format a cell using Custom hh:mm:ss.00 I don't see any custom option to create what I want. Is there some way to solve this, or perhaps I have missed it in Help.