In a data environment I write code like:
select ([exam fee]*[other fee]) as total from table1
then it work, but when I write like below it not work:
select sum[exam fee] as total from table1
what problem with it?
abu taher 34 Practically a Posting Shark
Recommended Answers
Jump to PostNOTE:
sum[exam fee] ==> sum([exam fee])
Jump to PostI don't understand by this code. I want sum[exam fee] and sum[other fee]. is it possible with your code?
yes.
SUM is a sql function. you must use '(' & ')' for it.change your code in this way:
"select sum[B]([/B][exam fee][B])[/B] as total , sum[B]([/B][other …
Jump to Postthanks Mtb 925. it works well. another thing when I input exam fee in a form and when I see the report it not update. I mean exam fee is 200 and I add again 200. so report will show 400/ but it show 200, when I exit and again …
All 12 Replies
vb5prgrmr 143 Posting Virtuoso
abu taher 34 Practically a Posting Shark
vb5prgrmr 143 Posting Virtuoso
abu taher 34 Practically a Posting Shark
Mbt925 0 Junior Poster in Training
abu taher 34 Practically a Posting Shark
Mbt925 0 Junior Poster in Training
abu taher 34 Practically a Posting Shark
Mbt925 0 Junior Poster in Training
abu taher 34 Practically a Posting Shark
Mbt925 0 Junior Poster in Training
dspnhn 10 Junior Poster in Training
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.