Re: DCount
- From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
- Date: Tue, 26 Jul 2005 14:36:39 GMT
Mark wrote:
> I used a text box instead of Cal and it did work, so looks like some
> format issue.
>
> However, I'm still getting some errors in my data from the field
> being (in the table) a combination of Date and time. Ex: 07/25/2005
> 5:09:35 PM
>
> When I run:
> vStr = DCount("WORK_REQ_ID", "VIAWARE_WCS_TO_VIA_T", "DTIMEMOD =
> #07/13/2005#"
>
> It shows none. What would I use to only see the date in a field?
There's the "easy but inefficient" method...
vStr = DCount("WORK_REQ_ID", "VIAWARE_WCS_TO_VIA_T", "DateValue(DTIMEMOD) =
#07/13/2005#"
And there's the more difficult but more efficient method...
vStr = DCount("WORK_REQ_ID", "VIAWARE_WCS_TO_VIA_T", "DTIMEMOD BETWEEN
#07/13/2005# AND #7/14/2005#")
If you think there's any chance of having records with exactly midnight then
you have to use...
vStr = DCount("WORK_REQ_ID", "VIAWARE_WCS_TO_VIA_T", "DTIMEMOD BETWEEN
#07/13/2005# AND #7/13/2005 23:59:59#")
The efficiency issue is that you (whenever possible) want to apply criteria
to a field directly rather than to an expression containing the field. The
latter prevents the database engine from being able to utilize an index
forcing a row by row table scan.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
.
- References:
- DCount
- From: Mark
- Re: DCount
- From: Rick Brandt
- Re: DCount
- From: Mark
- Re: DCount
- From: Rick Brandt
- Re: DCount
- From: Mark
- DCount
- Prev by Date: Re: Insert new procedure with built-in error handling
- Next by Date: Re: Mail Merge
- Previous by thread: Re: DCount
- Next by thread: default shortcut menus
- Index(es):
Relevant Pages
|
