100, 1000 og 10000 dele sekunder i et klokkeslet felt

I dont think you can :o(

Man kan vel gemme timer, minutter og sekunder i ét felt og 1000-delene i et andet.

Try this in the immediate window
?Cdbl(now)
You will get a number something like
37801.8169675926
Now try
?Cdate(37801.81696) and you will get
29/06/2003 19:36:25
The  37801 is the days since 30/12/1899 and the fraction part (8169675926)is the time. Using Access's date functions you cant display fractions of second but they are as far as I can work out stored in the dB. So its just a case of getting them in and then out again.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;130514

Det tror jeg ikke er rigtigt terry. jeg tror at 8169675926 skyldes manglende afrunding af (19:36:25/23:59:59)*99999, når du laver ?Cdbl(now). Der skulle nok have stået 81697, Jeg tror ikke at decimaltallene er et udtryk for at der er regnet i brøkdele af sekunder :o)

You may be right there hekla and if thats the case you could as you suggest have an extra field for the fractions of a second. Then its just a case of displaying them

Okay - den eneste løsning er altså at dele det i to felter?

It looks that way! No matter how you do it Access's date functions are NOT designed to display fractions of a second!

Det kunne altså ikke lade sig gøre at få et dato felt med 10000-dele.
Alternativet bliver derfor 2 felter, hvilket terry og Hekla kom frem til i fællesskab - derfor half and half.