Access Modules

[Sigmund]

i need to write a module that is assigned to a macro that will modify the following table

patientid dateofservice amountowed
123 1/2/00 $10.00
1/7/00 $15.00
1/15/00 $10.00
456 1/5/00 $10.00
1/8/00 $10.00
789 1/6/00 $30.00
1/9/00 $30.00

i need to be able to run a macro for the table that will input the patientid number in the other fields so that i can run the query for a total for each patient. I have never done this before and if someone can help i would it would be greatly appreciated.
thanx folks,
sigmund

 

[DougP]

You can make an update query.
But how do you know which record is going to have which patientID?
You need some kind of parameter.


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.