Index Part of Field

owain · September 29th, 2003, 04:13 AM

I have a Date/Time field that I want to index, however I only want to index the Date part of the field and not the time part.

Is there any way of doing this (in VB DAO)?

Regards
Owain Williams

tastaturbeschmutzer · September 29th, 2003, 09:01 AM

I think there's no point to that. date/time fields are usually stored in 32 bits, so date and time cannot be separated. If you need the index for faster access, then putting the index on the complete field should work fine.

Otherwise I'm not sure whether you need an index at all.

owain · September 29th, 2003, 09:19 AM

Thanks for your help, I didn't think it was going to be possible.

Regards
Owain Williams

sal · October 2nd, 2003, 09:03 AM

What are you trying to accomplish? There may be another way of getting a solution to your problem.

Sal

owain · October 2nd, 2003, 09:34 AM

Thanks for you interest in my problem. I am afraid it would take too long to explain my problem, and as it happens I have devised another (better) solution to the issue.

Regards
Owain Williams