Re: Form not allowing entry

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

From: Aaron Howe (anonymous_at_discussions.microsoft.com)
Date: 01/12/05 

Date: Wed, 12 Jan 2005 03:05:43 -0800

>-----Original Message-----
>"Aaron Howe" <anonymous@discussions.microsoft.com> wrote
in message
>news:1e9201c4f887$26e064d0$a501280a@phx.gbl...
>>
>> I've been through and looked at all the joins etc and as
>> far as I can see, there are no glaring issues...
>>
>> Here's the SQL:
>>
>> SELECT tblSuppliers.AgName, tblXInvs.XInv,
>> tblAgInvs.CltName, tblXInvs.AgInv, tblXInvs.ClrDate,
>> tblAgInvs.Value, tblAgInvs.WE
>> FROM tblSuppliers INNER JOIN (tblAgInvs INNER JOIN
>> tblXInvs ON tblAgInvs.AgInv = tblXInvs.AgInv) ON
>> tblSuppliers.AgName = tblAgInvs.AgName
>> GROUP BY tblSuppliers.AgName, tblXInvs.XInv,
>> tblAgInvs.CltName, tblXInvs.AgInv, tblXInvs.ClrDate,
>> tblAgInvs.Value, tblAgInvs.WE
>> HAVING (((tblXInvs.XInv) Is Not Null) AND
>> ((tblXInvs.ClrDate) Is Null))
>> ORDER BY tblXInvs.AgInv;
>>
>> It still doesn't make much sense to me I'm afraid...
>
>For a start, you should remove the GROUP BY, it's doing
nothing useful, and
>replace the HAVING clause with a WHERE clause.
>
>
>.

Fantastic, that works now. So it was the HAVING clause
that caused the issue? I don't totally understand why,
but now I have a starting point to investigate and see
what it does. Thanks again everyone for your help!

Relevant Pages

  • Re: Employees Pay Rate
    ... Now, for an INNER JOIN, you start with a CROSS JOIN, but you keep only the ... records where the ON clause evaluates to FALSE or NULL). ... FROM (tableOne As a INNER JOIN tableTwo As b ... GREATER the dateNewSal actually pointed by the second hand. ...
    (microsoft.public.access.queries)
  • Re: SQL to Linq - Left, Right and Inner Joins
    ... if the where clause is on an indexed column I'd ... be *hugely* surprised if the inner join were fully evaluated by SQL ... select distinct c.* from customers c inner join orders o ... The second query has less reads than the first query. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Employees Pay Rate
    ... Now, for an INNER JOIN, you start with a CROSS JOIN, but you keep only the ... records where the ON clause evaluates to FALSE or NULL). ... FROM (tableOne As a INNER JOIN tableTwo As b ... GREATER the dateNewSal actually pointed by the second hand. ...
    (microsoft.public.access.queries)
  • Re: update query: still having problems
    ... Only the records from Department that have a rate value present in sheet1, ... That is how an INNER JOIN works when there is no duplicated values (in one ... you add an extra WHERE clause. ... Your code throws up a syntax error: ...
    (microsoft.public.access.queries)
  • Re: sql query syntax - joins without join syntax
    ... explicit INNER JOIN requires the INNER. ... Without the WHERE clause implying two tables, ... >> 5) how do you do outer joins, for example, using only the where clause ...
    (microsoft.public.access.queries)