[RESOLVED] help with SQL and dates and update

[rasty1611]

1.How can you select the fields with an SQL statement and using a date column. For example:

.RecordSource = "Select * from tableA where Adate between " & txtDate1 & " and " & txtDate 2

2.Can I get somehow the records that i need and perform calculations with them and save the calculation result in another column in the same records?

for example, with a loop add number1 and number2 to result which all are columns in my database? I can send the code if you prefer...
in a for loop:
(.Fields(10)) = (.Fields(2))+(.Fields(3))
how do I update (.Fields(10))??