Re: Need Help With a Module



What is the purpose of looping through the records?
To sum them?

Would this work:
=DSum("Field1", "Table1")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Anne" <Anne@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1551025F-248C-4825-9B6D-F898056057D3@xxxxxxxxxxxxxxxx
>I want to loop through a recordset and capture the value in a field. There
> could be as many as 18 records..... do I declare strValue1, strValue2..
> etc., or can I declare a value as I go along..... I have Friday head and
> am
> lost.
>
> Thanks for your help!


.



Relevant Pages