My quickbooks 2006 file has approx 11,000 invoices/records in the Invoice table.  I need to reprint approx 1200 nonsequential invoices so I have created a table in access that has the 1200 invoice numbers.  I was going to join the two tables based on refnum and invoice number and update the Istobeprinted field in the invoice table to '1'.  The query runs for hours and hours and just hangs.  What optimization and/or SQL syntax should I be using.  All the invoices are post nov 06 if that is any help.

Basically you are going to need to setup a programming loop that reads each invoice number and executes:

DoCmd.RunSQL "UPDATE Invoice SET IsToBePrinted=1 where RefNumber = [invoice number variable]"

If you're saying that you just want to reprint everything after Nov'06 then you could just run this SQL Statement using VB Demo:

UPDATE Invoice SET IsToBePrinted=1 where TxnDate > {d'2006-11-30'}

does this look ok?

----------------------------

Private Sub Command5_Click()

dim rs as DAO.Recordset
dim i as long

set rs = currentdb.openrecordset(Tablename,dbOpendynaset)
rs.movelast
i = rs.AbsolutePosition

do while i >=0

DoCmd.RunSQL "UPDATE Invoice SET IsToBePrinted=1 where RefNumber = [WorkTbl]![inv#]"

rs.moveprevious
i = i - 1

loop

set rs = nothing

End Sub