VBA Help on DoCmd.GotoRecord

[elephant97]

Here is my code:

DoCmd.GoToRecord acDataQuery, "Build Query", acGoTo, 1
Let Text606 = [FTMR]
Let Text678 = [Outstanding_Discrep]


DoCmd.GoToRecord acDataQuery, "Build Query", acNext
Let Text 607=[FTMR]
Let Text679=[Outstanding_Discrep]

'''''''''''''

I am obtaining the correct value for text606 & text678. My problem is that I need the doCmd to pull the value for the next record in the query but it continues to report the same values for 607/679 as are listed for 606/678. Help!

 

[zacemmel]

What kind of a query are you doing? and against what kind of data?

 

[elephant97]

Here is an image of what my data query will report. What i'm looking to do is report the information on row 1, the information on row 2, and an average of the values in each column. Thanks!

 

[elephant97]

I still haven't found a solution to this problem. Can anyone help me?