ADODB Shape Command ERROR

[Capritarius21]

What's wrong with the code, pls help:

setCon adoJOReport
adoJOReport.RecordSource = "Shape{Select SUM(Cost) as SC,SUM(Price) as SP,Brand From Temp_JOMaster Where JoNumber='" & txtJO.Text & "'Group by Brand} " _
& "Append ({Select * From Temp_JOMaster " _
& "Where JOnumber='" & txtJO.Text & "'} Relate Brand To Brand) As Command2"
adoJOReport.Refresh

Any help will be greatly appreciated.

[Capritarius21]

To be specific, the error was:

DATAFIELD '(EMPTY)' NOT FOUND

This error occur when I try to open the DataReport
generated by my shape command stated above.

[Capritarius21]

Already solved the problem, ahehe!

It's just that I put report textbox in my DataReport
that is not included in my flooding code.