Querie then Count the results...

[Brando]

I have two tables: "Vender" and "Jobs". I want a field (named "2006") in my vender-profile form to display the number of times in 2006 that that vender's name appears in the "Vender" field of my Jobs table. I hope to repeat the code for other fields ("2005", "2004" & "2003").

Any suggestions?

--Brando

 

[FoFa]

1 - I would not store that value.
2 - Use a parameter query to specify the year you want and vendor.
3 - Run your count query on demand.