Re: Like

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



"David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx> wrote in message
news:Xns9B8CBCDECE762f99a49ed1d0c49c5bbb2@xxxxxxxxxxxxxxxx
"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.).

You're right. That's what happens when you only look at the problem section
of the query, not its intent.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


.

Relevant Pages

  • Re: Missing Operator Problem
    ... Doug Steele, Microsoft Access MVP ... (no e-mails, please!) ... "Benjamin" wrote in message ... Im using the DSum(DomSumme in german) function to sum up ...
    (microsoft.public.access.queries)
  • Re: Simple Expression - Fumbling Around
    ... Doug Steele, Microsoft Access MVP ... (no e-mails, please!) ... I am trying to write an expression so that a Sum on my report page will ...
    (microsoft.public.access.gettingstarted)
  • Re: sql check please
    ... If any of the fields contain a Null value, the sum is going to be a Null. ... Doug Steele, Microsoft Access MVP ... (no e-mails, please!) ... > FROM payments ...
    (microsoft.public.access.queries)
  • Re: Not returning a value
    ... Doug Steele, Microsoft Access MVP ... (no e-mails, please!) ... But I'm still not getting a Sum of Total. ...
    (microsoft.public.access.formscoding)
  • RE: IIf statement
    ... This is a start but the idea was to have it sum ... Barry Guidry ... "Duane Hookom" wrote: ... Microsoft Access MVP ...
    (microsoft.public.access.queries)