Re: query returning either nothing or multiples of records

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

Sorry I really feel like I am banging my head against a wall with this, would
it be possible to e-mail a copy of the database to you and you could have a
quick look at the tables and relationships? I know that?s a lot to ask and I
completely understand if you are not willing to do that!! I appreciate all
the help you have been gracious enough to give me.

Allen Browne wrote:
>The answer to your general question is, Definately! The joins dicatate which
>data is selected. If there are no matchs, you get no results. If the joins
>are wrong, you may get no results.
>
>You say the 2-table query works, but the 5-table query does not. There are
>several steps to investigate between these 2 to discover at which point the
>problem occurs, i.e. which join yields no answers, or which combination of
>joins is the issue.
>
>> Thank you so much for your help i really do appreciate it and sorry I keep
>> explaining my self poorly.
>[quoted text clipped - 52 lines]
>>>>>> the
>>>>>> records being more than halved.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200508/1
.

Relevant Pages

  • LDAP
    ... I have been banging my head into a wall trying to get one ... the database and try over from scratch. ...
    (freebsd-questions)
  • Re: Troubles with a parameter query
    ... Can you run the query without the form? ... Here is my SQL. ... FROM [Q and D Database] ...
    (microsoft.public.access.queries)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
    (microsoft.public.access.conversion)