Please Help me Writing this SQL

[viron]

i want to add two fields from my table (eg in my table field

FieldID Field1 Field2 : How can i add Field1 & Field2 Using SQL Query.. and put the result in Data Report Designers in VB..


Output: FieldID Field1 Field2 Total
1000 5 6 11


Hope you can help me...
Thanks a lot

[Killer42]

I don't know anything about the Designer, but to add two fields in your SQL, I believe the syntax is "[field1]+[field2] As Total".