p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Index Part of Field (http://p2p.wrox.com/showthread.php?t=4383)

owain September 29th, 2003 04:13 AM

Index Part of Field
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)?

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.

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.


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.

Owain Williams

All times are GMT -4. The time now is 04:55 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.