disgruntled
Registered User.
- Local time
- Today, 19:17
- Joined
- Jul 3, 2001
- Messages
- 38
The big picture: I have imported a range of cells from an excel doc into a acces table. I have added and extra field to this table titled "ERROR". I run various SQL queries on the data comparing it to the data in my database and will eventually create a report of the discrepencies. As a result of the various queries I am left with many recordsets.
What I would like to do:
(1) Run through each RS individually adding a description of the error to the ERROR field in the RS.
(2) Append the RS's together and send to my report as the rowsource.
So my questions are how do I add data to a field in every record of a RS and can I append RS's together?
Any help/thoughts would be fantastic.
What I would like to do:
(1) Run through each RS individually adding a description of the error to the ERROR field in the RS.
(2) Append the RS's together and send to my report as the rowsource.
So my questions are how do I add data to a field in every record of a RS and can I append RS's together?
Any help/thoughts would be fantastic.
