Member Avatar for johmolan

I tried to sum a column using the

Dim myValue As Double =myDt.Compute("Sum("total cost"),"Condition")

But I ony end up with the result.

SyntaxError:SytaxError in argument: expecting an argument for singel column with possible "Child"-qualificator.

Anyone knows what I do wrong

I tried the same code with the column quantity and it worked great
bet not with the total cost column.

I am kinda lost.

  • 2 Contributors
  • 1 Reply
  • 79 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by sknake
Member Avatar for sknake

Is it because of the space in the name? Try "[total cost]" and "total_cost" to see if that fixes it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.