[RESOLVED] Data Report Error

hi everyone! im a vb beginner and im encountering error like this: "incorrect syntax near '10001'" on my data report everytime i execute it.

Problem: whats the correct query of my code below,'coz im trying to set my report or group it by ProdType

Set rs = con.Execute("Select ProdNo, ProdDesc, Qty, UnitPrice, TotalAmt,Prodtype, Count(') as ProdType from tbl3DRitems where DRno = '" & Combo2.Text & "' group by ProdType")


Can anyone give me some insight into what might be causing this problem?

Thanks,
ishee

WELCOME ishee17:afrog: :wave:
you haven't declared what is con, rs. First declare them followed by setting them.

Quote:

---

Originally Posted by VBFnewcomer

WELCOME ishee17:afrog: :wave:
you haven't declared what is con, rs. First declare them followed by setting them.

---

thanks for the response and for your warm welcome!

:afrog: :eek2: :eek2: :wave:

Quote:

---

Originally Posted by VBFnewcomer

WELCOME ishee17:afrog: :wave:
you haven't declared what is con, rs. First declare them followed by setting them.

---

i changed the problem.. im using ms sql8 DB. :)

Quote:

---

Code:

---

Set rs = con.Execute("Select ProdNo, ProdDesc, Qty, UnitPrice, TotalAmt,Prodtype, Count(') as ProdType from tbl3DRitems where DRno = '" & Combo2.Text & "' group by ProdType")

---

---

I'm not sure about that, Can You duplicate field names?

Quote:

---

Originally Posted by jggtz

I'm not sure about that, Can You duplicate field names?

---

either i duplicate it or not still the same error.. :confused:
but if some one could tell me another way of grouping records without using data environment wouldl be a great help....

Quote:

---

Originally Posted by ishee17

either i duplicate it or not still the same error.. :confused:
but if some one could tell me another way of grouping records without using data environment wouldl be a great help....

---

i got it now i just searched the sql syntax of group by clause. :)