accessing feilds in a table

[jwlnewsome]

Ill start from the dawn of time

right all tables are like a 2d array so does any body know how i can access a field in a row of a table ie like in most languages it goes a bit like this ArrayName(1,1) with ArrayName being the name of the table and that access the first field of the first row. im new to Vba and access 2000 but all i want to do is access the fields in a column of a sub-form displayed as a table add them all up and place the answer in a text box on the main form stick all this in a function so i can run it inside a macro

q1 is this possable
q2 how do you do it

thanks in advance john

 

[KenHigg]

You can probably do what you need with DAO or ADO...

a. Search here for more info...
b. Google it (them)...
c. Get a good book...

 

[jwlnewsome]

hello ken

got any good sites for the sort of info i need

thanks in advance john

 

[Ian Mac]

Q1 Yes it is
Q2 Dunno

Reason I dunno is, you are thinking in terms of VB/VBA and what you really want to do is look at a recordset of data.

As you know programming, look at the help for SQL within Access.
This will give you a better understanding of how the data is presented.

Please post back with questions.

Cheers,

 

[jwlnewsome]

Thanks pat nice one

john