WMitchellCPQ
Programmer
I have a table-
tblPlantedOn
SeedID | field2 | FarmID
12,1,4
12,2,4
1,2,4
1,4,5
I want to figure out which farms have only one type of seed planted on them.
The one thing that is causing me problems is that the two entries on farm 4 only count as one seed. This anyway is discounted here as another seed type - 1 is planted on farm 4. This one query is killing me
Any ideas folkes ?
tblPlantedOn
SeedID | field2 | FarmID
12,1,4
12,2,4
1,2,4
1,4,5
I want to figure out which farms have only one type of seed planted on them.
The one thing that is causing me problems is that the two entries on farm 4 only count as one seed. This anyway is discounted here as another seed type - 1 is planted on farm 4. This one query is killing me
Any ideas folkes ?