| Barley Man 2005-10-31, 7:24 am |
| Sorry Guys! My stupidity entirely!
Anders spotted the problem!
To make the process understandable in a 'question' I had subtitued the
concept of Staff for something far more esoteric called 'Pathway'. In my
stupidity, I'd forgotten that the equivalent of STREFNO was NOT unique and
that I could have almost any number of entries with the same refno.
Sorry to have wasted your time but I don't think I'd have spotted my
stupidity without Anders' help.
Pretty impressive! Nt only do you fix Fox probelms but you can correct
stupidity too!
Thanks to both of you. Your help, as always, is invaluable!
Regards, Ian
"Anders" wrote:
> If there are an new row in Followup for every staff person connected to the
> followup your query will get those rows.
> You shouldn't get row for staff members not individually personally
> connected to that particular follow-up.
> Is Staff.strefno a primary key for a single individual?
> What does
> SELECT strefno , COUNT(*) FROM Staff GROUP BY strefno ;
> HAVING COUNT(*) > 1
> It should return an empty query result set.
>
> -Anders
>
> "Barley Man" < BarleyMan@discussion
s.microsoft.com> skrev i meddelandet
> news:46EBE841-A674-46E4-AA72- FA9F513365C0@microso
ft.com...
>
>
>
|