I have a table that i want to automatically up date, not sure how to do it. I
want it to look through another table and everytime it finds a certain value,
i want it to check another colum to see if it has a certain value and count
the number.

eg look up colum A looking for the number 3760 and for every row with 3760
then look in column B to see if it has the value "Ex" and if it does count it
(add one to the total) and then put the final value in my other table to be
used for reporting (charts,graphs,etc)

Is this possible???

Cheers