Time field

[leighms]

Hi

I currently have a table records calls received. Part of the table has a field for date and another field for time.
I have a query to calculate calls received & the reason during each month, however the problem I have is it does not work, because the time field records the date as well, when I delete the date portion in the time field the query works fine.
Is there anyway I can set the time field in the table to record the time only and not the date and time

Regards

 

[pbaldy]

How do you populate it? It sounds like you're using Now(), and you just want to use Time(). Frankly, I'd use a single field with the combined date and time anyway.

 

[leighms]

Hi

I am using =Now(), so it automatically updates, do I need to change to =Time()?

 

[pbaldy]

I thought I suggested that, yes.

 

[leighms]

Hi

Thanks, i have tried changing that however it still records the date & time. I have the time set to medium time.
On the form & in the table it only displays the time, however when I run the query it won't pick up the time as the date is still being recorded

 

[pbaldy]

I can assure you that the Time() function is only putting the time in. What is the date? If it's an actual date, you have some other process adding a date to that field. If it's 1900 or whatever, that's just the equivalent of a zero date.

 

[vbaInet]

... and old records will still contain the Date part unless you Update the records using a query to get rid of the Date part.