 |  |  |  |  |  |  |  |
sql commad problem
 |
•
•
Join Date: Jul 2008
Posts: 633
Reputation: 
Solved Threads: 43
Practically a Master Poster
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?
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?
I like sword. Attack or Defense.
my web
my web
•
•
Join Date: Mar 2009
Posts: 1,214
Reputation:
Solved Threads: 220
How does it not work?
and should that not be ([exam fee] + [other fee])
Good Luck
and should that not be ([exam fee] + [other fee])
Good Luck
If anyone has helped you solve your problem, please mark your thread as solved.
Thanks
Thanks
•
•
Join Date: Jul 2008
Posts: 633
Reputation:
Solved Threads: 43
Practically a Master Poster
another thing. I write like:
"select sum[exam fee] as total , sum[other fee] as total_fee from table1"
it not work
"select sum[exam fee] as total , sum[other fee] as total_fee from table1"
it not work
I like sword. Attack or Defense.
my web
my web
•
•
Join Date: Mar 2009
Posts: 1,214
Reputation:
Solved Threads: 220
Are the fields numeric? If not that could be your problem but without seeing your code who knows.
Good Luck
Good Luck
If anyone has helped you solve your problem, please mark your thread as solved.
Thanks
Thanks
•
•
Join Date: Dec 2007
Posts: 62
Reputation:
Solved Threads: 5
Junior Poster in Training
NOTE:
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
•
•
Join Date: Jul 2008
Posts: 633
Reputation:
Solved Threads: 43
Practically a Master Poster
•
•
•
•
Originally Posted by Mbt925 
NOTE:
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
I like sword. Attack or Defense.
my web
my web
•
•
Join Date: Dec 2007
Posts: 62
Reputation:
Solved Threads: 5
Junior Poster in Training
•
•
•
•
Originally Posted by abu taher
I don't understand by this code. I want sum[exam fee] and sum[other fee]. is it possible with your code?
SUM is a sql function. you must use '(' & ')' for it.
change your code in this way:
"select sum([exam fee]) as total , sum([other fee]) as total_fee from table1"
•
•
Join Date: Jul 2008
Posts: 633
Reputation:
Solved Threads: 43
Practically a Master Poster
thanks 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 open the project then show 400. please help me
I like sword. Attack or Defense.
my web
my web
•
•
Join Date: Dec 2007
Posts: 62
Reputation:
Solved Threads: 5
Junior Poster in Training
•
•
•
•
Originally Posted by abu taher
thanks 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 open the project then show 400. please help me
you must reconnect it. attach your sample. i will edit it.
|
Similar Threads
- sql query problem with MS Access and C# (C#)
- SQL in VB.NET problem (VB.NET)
- Problem with php and SQL (PHP)
- another MS SQL timeout problem (MS SQL)
- Weird ASP/SQL Problem (ASP)
- SQL query problem with WHERE clause (ASP)
- SQL date problem (MS SQL)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: How to create activation key for VB Application
- Next Thread: date show in datareport
Views: 715 | Replies: 12
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 access activex add application banned basic beep c++ calculator cd channel9 click client code coffeehouse college column convert copy creative database designer desktop dissertations dissertationthesis dissertationtopic edit error excel file filename filter flex form grid group hardware ide image implements inboxinvb installation installer label list listbox listview looping machine macro mail match memory messagebox microsoft number open pos prime print printer programmer prompt query random range range-objects readfile reading registration remotesqlserverdatabase report reports retrieve save score search sites sound spectateswamp sql string sum table textbox time variable vb vb6 vb6.0 vba vista visual visualbasic web window windows
