Having trouble with a recordset/array in selecting and appending values from 2 column

[Dal Jeanis]

For tables, an Alias can be thought of as a virtual copy. "MyTable AS XXX" means that XXX now refers to a copy of Mytable. It's as simple as that.



An Alias for a field can be thought of as a virtual field. "MyField AS NewName" means that NewName refers to MyField. "(3 * MyField) As TripleMyField" means that TripleMyField refers to the product of MyField and 3.

[mt1013]

So "TM1" AND "TM2" considered virtual copies of tblWorksheet?

Hello. Having trouble with the query. Question: does the tblworksheet contain an autonumber (like "tblKeys")?

Thanks

[Dal Jeanis]

Yes. I believe I called it WorkPK. See post 6.

[mt1013]

Yes. I believe I called it WorkPK. See post 6.

Dal

I'm slowly getting there. I actually got it to run once - just like wanted - complete with data in the right place. Then I went back to it the next day and it didn't work: the "Match ID" isn't pulling in the "work id" of those that match. The column just shows zeros. Any suggestions you might will be greatly apreciated.

[Dal Jeanis]

Hmm.

FIRST ITEM: General rules for development

1 - Back up the database early and back up often. For backups, I append the date and a letter on the end of the db name. The third copy today of MyDb.accdb would become MyDb 2013-1107c.accdb, for example.

2 - Do all programming and testing in a junk copy of the database. When you think the update is working, take a fresh copy of the real database and port in just the changes that you think made the update work. Test thoroughly. If it still works, then you have a new production database. Back it up again, and start your next work in another junk copy. (This method keeps you from accidentally leaving test changes and test data in the live database.)

3 - Clean up your backups occasionally. Basically, when enough time elapses that you aren't likely to need to investigate changes between in-day backups, delete all but the last working backup of each day. Separately, you'll keep your periodic production backups on whatever schedule they are needed for business purposes.

SECOND ITEM: Debugging this issue

Please post the code for each of your queries. Have each query in its own [ code ] and [ / code ] tags.