>I found the function is COALESCE. But I still only get 66 records not 70.
>
>My situation is this.
>
>I have a table that has 70 item definitions in it (myDefTable).
>
>I have a table that stores records of Assy Index Numbers, item definitions, status, comments (myItemStatusTable).
>
>I want to create a list(cursor) that shows all of the item definitions and where records match to show the status and comments values for a particular Assy Index Number.
>
>I hope this makes sense.
Check Sergey's answer (I'm sure you already did :o)))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.