Newbie Access Programer

[David]

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

 

[Daniel Pineault]

If I understand what you are wishing to do, take a look at

http://www.devhut.net/index.php?lang=en&pid=0000000011#recsets

simply replace the Table1 with your query name.

If this isn't what you are looking for, please explain your needs further.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.