Using Adodc control to subtract Queries Result

[Sajjad_1]

i want to run this Query with ADODC control and show result in Datagird View

Private Sub Command1_Click()
Dim Sell_tbl, Stock_Bottle, res As String


Sell_tbl = "SELECT Sum((Quantity)*12) FROM Sell_Detail Where Cateogry='Large'"
Stock_Bottle = "Select Sum(No_Of_Bottle) FROM Add_Bottle Where Cateogry='Large'"

res = ((Sell_tbl) - (Stock_Bottle))

Adodc1.RecordSource = Sell_tbl
Adodc1.Refresh
Adodc1.Caption = Adodc1.RecordSource
End Sub

Error show
Type Mismatch

[Minimalist]

Only glancing at it, you declared your variables as string but then try to do some calculation with these in line 8. Need to change into some number type, int, long ?

[Sajjad_1]

I CONVERT IT INTO int datatype but still not working

[Minimalist]

Your select statements could be also wrong. May be try:
"SELECT Sum((Quantity)12) FROM Sell_Detail Where Cateogry=" & "'" & Large & "'" and I am not sure if you have take this Sum((Quantity)12) also out of the string.

[Sajjad_1]

my queries are running fines when I run Only one Query else when i combine them to ind sum it shows error..
Syntax error Missing operator

[Sajjad_1]

or Quotes are nested what i experience Because by your previously post i just remove them and i got error..

[Minimalist]

Well I would put some error checking in. After each select statement use debug.print() to see if your selects return what you expect. MAybe googlee for some select statement code and compare this to what you've got becxause I don't think you got it correct.

[Sajjad_1]

Thanks about debug.print but the problem is still remain it couldn't subtract one query reult with the other Please Help

[Minimalist]

Well, do you know what is returned?

[Minimalist]

I don't think my advise was any good with your queries. Better have look at:
http://technet.microsoft.com/en-us/library/cc966377.aspx
and take it from there.

[abelingaw]

I suggest you use ADODB for this one.

Read THIS.