Recent content by kcushing

I had the same issue. I had to size down all the text fields in my Access table to 127 characters. Then when Access creates the dbf, it can insert the records. I also cut all my field names to 10 characters and my table name to 8 characters, but you may not have to do that.

I like that format. The problem I have is when it get to over 24 hours it wraps back to 1 instead of showing 25 hours like I want so I went with a combination of the two: Format(Int(Sum([CallLenth])/3600),"00") & ":" & Format((Sum([CallLenth])/86400),"nn:ss") This way 91511 seconds shows...

Yes, thank you. That will be a big help!

I am trying to do the same thing. Databases I created with an older version of Access do this already. But newer datasheets are tabbed and I can view only one at a time. I am sure there is a setting somewhere to allow me to view the tables one above the other. I am linked to two different...