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 PostHow does it not work?
and should that not be ([exam fee] + [other fee])
Good Luck
Jump to PostAre the fields numeric? If not that could be your problem but without seeing your code who knows.
Good Luck
Jump to PostNOTE:
sum[exam fee] ==> sum([exam fee])
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.