On 11 Jan 2007 23:53:49 -0800, "kev" <kevi.mel@gmail.comwrote:
Your query apparently used inner joins. That's why only records with
presence in all tables show up. Click the join line in query designer,
and switch to an outer join (all from equipment, and matching from
<other table>)
-Tom.
Quote:
>Hi folks,
>
>Firstly, Happy New Year to all. I have some problems with query pls
>help.I have 4 tables namely Equipment,Safety1,Safety2,Safety3. some of
>the fileds in each table is shown below.
>equipment: requestorname,building,equipmentid(pk),WWID
>safety1:status,equipmentid
>safety2:requeststatus,equipmentid
>safety3:status3,equipmentid
>
>Now i would like to create a search by which a user searches using his
>WWID(working id)[a combobox] to check and see how many requests has he
>made and the status on each level.After searching, i want the results
>displayed as below:
>
>requestorname(from table equipment) | equipmentid (from table
>equipment)| equipment name(from table equipment) | status(from table
>safety1) | requeststatus(from table safety2) | status3(from table
>safety3)
>
>I tried creating a simple query but it only lists out all the equipment
>which has corresponding status in all three levels.what i want is
>something like maybe the user has completed level 1 and the status is
>pending, at the columns for status level 2 and level 3 i would like to
>appear as string "Not Applicable". So when a user looks at this
>statement, they are aware that they have not completed level 2 and
>level 3.
>
>Basically, when a user registers for an equipment, it will be stored in
>equipment table. next, some users prefer to proceed to safety level 1
>at another time, thus by creating this query i would like to help the
>user to recall all his requests plus he gets to know d status for each
>level.
>
>pls help me.
>
>thanks.
