I get the error that is attached as a picture here when i run this query on vba.
any ideas?
Set RsType = CurrentDb.OpenRecordset("SELECT SOBP,SOBPDEBIT FROM RFGDebitNotes ;")
Set RsTbl = CurrentDb.OpenRecordset("SELECT * FROM " & RsType!sobpdebit & " ;")
strsqlDBl = " SELECT * FROM " & RsType!sobpdebit & " ORDER BY " & RsTbl!Credits & " Desc;"
strsqlDBm = " SELECT * FROM " & RsType!sobpdebit & " ORDER BY " & RsTbl!Debits & " Desc;"
any ideas?
Set RsType = CurrentDb.OpenRecordset("SELECT SOBP,SOBPDEBIT FROM RFGDebitNotes ;")
Set RsTbl = CurrentDb.OpenRecordset("SELECT * FROM " & RsType!sobpdebit & " ;")
strsqlDBl = " SELECT * FROM " & RsType!sobpdebit & " ORDER BY " & RsTbl!Credits & " Desc;"
strsqlDBm = " SELECT * FROM " & RsType!sobpdebit & " ORDER BY " & RsTbl!Debits & " Desc;"
Attachments
Last edited: