Re: Like

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxx> wrote in
news:Oa1hJRPcJHA.4072@xxxxxxxxxxxxxxxxxxxx:

"HAVING (((tblHouse.[Consignee Client Name]) Like '*TO*' And
(tblHouse.[Consignee Client Name]) Like '*ORDER*') AND (

Uh, those look like WHERE clauses. HAVING should be used only on
summarized values (SUM, MAX, FIRST, etc.).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Sum up
    ... now Time Warner is apparently trying to save children by limiting my ... access to Usenet though their service. ... Can someone sum up for me? ...
    (rec.sport.football.college)
  • Re: X3SAT Question
    ... Given a collection of clauses, ... Just produce a reduced X3SAT instance that is unsatisfiable. ... The sum of weights of vertices in the VC must equal 2m. ... add "abg" to the neighbor sets of the remaining vertices. ...
    (comp.theory)
  • Re: Access 2007: Creating a local relationship between two remote ODBC tables
    ... since you're altering something in a Jet MDB ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
    (comp.databases.ms-access)
  • Re: Is there a Stuff() Function or equivalent in MS Access
    ... If search for Midin VBE help in Access, ... with its own Help article and example code. ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
    (microsoft.public.access.modulesdaovba)
  • Re: We love Apple!
    ... Just eyeballing the data it appears this group is in decline ... A sum of each year would have been nice. ... Not sure how indicative this group is of usenet *in toto*. ...
    (comp.sys.mac.system)