Re: Text Box in Form vs. User-Defined Criteria

On 21 Mar 2007 07:03:51 -0700, mjbruesch@xxxxxxxxxxxx wrote:

Any ideas?

Yes. Don't use LIKE on date/time fields!

LIKE is appropriate only when you want to use wildcards to search in a Text
field. A LIKE query without wildcards on a date field forces Access to convert
the date/time field to a text string, and search that text string (without the
benefit of any index on the field).

Just use the default = operator, and be sure there's an index on the date
field in your table. You should get sub-second response unless your table is
truly enormous.

John W. Vinson [MVP]
.

Relevant Pages

  • Re: Access 2000 help with Mid and InStr
    ... difference between two Date/Time fields. ... So in your query you put the following expression in a field of your query: ... but because it is in a string I have been unable to work on it ... >> Bob, ...
    (microsoft.public.access.gettingstarted)
  • ICE + Javascript validation script != success
    ... I have been struggling for days to solve this problem and every ... I have lots of pages setup that query correctly and work really ... the form and add the wildcards for the user. ... send_string before the submit, it has wildcards in the string as I ...
    (comp.databases.ingres)
  • GET and POST dropping wildcard characters in DB query
    ... I have been struggling for days to solve this problem and every ... I have lots of pages setup that query correctly and work really ... variables and GET and no JS, but the wildcards have to be explicitly ... send_string before the submit, it has wildcards in the string as I ...
    (comp.lang.javascript)
  • Re: WildCard Key
    ... But I have a new need to support filenames based on wildcards. ... I'd use a prefix tree aka trie both ... An empty string matches a terminal vertex ... stars that contains at least one star, ...
    (microsoft.public.vc.stl)
  • Re: wildcard woes
    ... Thinking the wildcards would work I try this ... In brief, Filemaker does a word search from the beginning of a word, for any string you put into a field. ... So for your desired searching a single request with "red yellow" in the field will work. ... These might be of assistance if you look them up in the help file and see how they are used in FM. ...
    (comp.databases.filemaker)
Loading