Search results

I am a seasoned access user but I am expanding my database nationally, the use of VB would be of great help. I converted a macro into VB and then added to it but it will not run. Here is the code. Please let me know what I am doing wrong it errors out immediately. Option Compare Database...

I have spent so much time on this but I cannot get it return only those rows where "Sorter" is unique and rate is the lowest for that group (Sorter) The table looks like this: Sorter Lender Loan Rate Price APR 101 1 $49,999.00 5.250%...