Tracking missing records

[c8tz]

Hi,

We have a tree census done every so often, everytime a census is done,
a tree must be given a status code - there are cases that some trees
haven't been recorded or possibly missed during data entry.

I need a query such that it will run through block and if it locates a
missing tree - it'll show this. There are a set number of trees in
each block.

sumthing like,
tree = 1

for tree if present end
tree+1
if no tree+1 then output

I hope I am clear.

Thanks

 

[pietlinden]

Hi,

We have a tree census done every so often, everytime a census is done,
a tree must be given a status code - there are cases that some trees
haven't been recorded or possibly missed during data entry.

I need a query such that it will run through block and if it locates a
missing tree - it'll show this. There are a set number of trees in
each block.

sumthing like,
tree = 1

for tree if present end
tree+1
if no tree+1 then output

I hope I am clear.

Thanks

(D) not enough information.
what are your table structures? Do you have a "Trees" table? Or what
does your census table look like? If you have a static list of trees
(in something like a "trees" table, you can use an outer join to find
the trees without a corresponding record in the "measurements"
table...

But without table structures, it's hard to be sure what's the best way
of doing this.