Hi Steve,

If agency is not in the observe table than there is no activity for that agency. Or I'm missing something?


>This is my SELECT - SQL command.
>

>SELECT DISTINCT agency.agency FROM agency WHERE agency.agency ;
>	NOT IN (SELECT observe.agency FROM observe) AND ;
>	observe.date>=CTOD(sdate) AND observe.date<=CTOD(edate) AND ;
>	(ALLT(observe.activity) <> "Visit- Station" AND ;
>	ALLT(observe.activity) <> "Visit- Hospital") INTO CURSOR agcy
>

>Is this command ignoring the fields observe.date and observe.activity the way I have it written? If this command is wrong, how can I change it so it shows me agencies in the Agency table that are not in Observe table, but falls within those dates and not those particular activities in the Observe table?
>
>Thanks for the information. Much appreciated!