Recent content by miniwheat51

Calc_Diff and CopyOfAll_Grouped are tables and don't contain SQL, to my knowledge. As for the purpose of the rsAll.MoveNext occurrence, the code is supposed to determine if the difference between [Amount] and [Amount_Cur] is less than 0. If it is, then make the TotAmt the AvgDiff (the...

So, when I wrote out the fields I needed in each SQL statement I made some changes to what I believed to be errors. I'm now getting an error message that states "qdf!Invoice_Num does not exist" in the first loop. Set rsDiff = CurrentDb.OpenRecordset( _ "SELECT Invoice_Num, Amount...

Not sure what you mean? It was my understanding the query was being created within that recordset.

First, thanks so much for your reply. I have posted this in other forums for several weeks and you're the first person I've heard from. I changed rs.Inv to rs.All as it was an error (some residual name left from where I got the code.) However, my error seems to be occurring within the...

I'm not new to VBA per se, but I've not had to do something this complicated before and my knowledge of loops is not great. I've done research for weeks and am using this only as a last resort. I was able to find some code to help me but it's riddled with errors and I can't figure them out...