Hi
I have several years experience with Excel VBA
I'm hoping someone can give me a kick start with access VBA example code
for the following simplified example:
tbl_Fruit has 2 fields: WeekNumber, Fruit (4 varieties)
QueryFruit has CountOf Fruit for a specified WeekNumber
How would I cycle through many week numbers and output and capture the query
result for each?
Thanks