Re: Need help w/ Challenging Query

From: Gary Walter (garylwpleasenospam_at_wamego.net)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 09:19:45 -0500

Hi Tom,

try

SELECT Branch, Billet
FROM yourtable
WHERE
(((Switch(Len([Branch])=4,[Branch]<>Left([Billet],4),
Len([Branch])=5,[Branch]<>Left([Billet],5),
Len([Branch])=6,Left([Branch],5)<>Left([Billet],5),
True,False))=-1));

Please respond back if I have misunderstood.

Good luck,

Gary Walter

Relevant Pages

  • Re: Formatting date query Column by week.
    ... Please respond back if I have misunderstood. ... Good luck, ... Gary Walter ... > employees. ...
    (microsoft.public.access.queries)
  • Re: Null Query
    ... [SomeField] ... Please respond back if I have misunderstood. ... Good luck, ... Gary Walter ...
    (microsoft.public.access.queries)
  • Re: Creating empty date field with make-table query
    ... > Another clever method Michel once demonstrated: ... > Please respond back if I have misunderstood. ... > Good luck, ... > Gary Walter ...
    (microsoft.public.access.queries)
  • Re: Date range criteria
    ... "Gary Walter" wrote: ... > Please respond back if I have misunderstood ... > Good luck, ...
    (microsoft.public.access.queries)
  • Re: Licence for Access
    ... the link led to instructions to reinstal after renaming a ... >Hi Sheila, ... >Good luck, ... >Gary Walter ...
    (microsoft.public.access.queries)