0

I was developing a 'Payment Tracker' web application. I used MS Access as back-end database. I made a 'Payment_entry' table with user_ID and Payment_amount fields with 'Text' and 'Long integer' datatypes. Now , when I wanted to find the total payment of each user I used the following SQL command :
Select user_ID , SUM(payment_amount) From Payment_entry Group By payment_amount ;
But unfortunately I got strange result from the command. Then I got back to my database and reset the datatype of Payment_amount field from Long integer to Decimal. Then I again applied the SQL command. This time I got the correct result. From this , I think that the Sum( ) function does not work correctly with the long integer datatype. Am I correct in this decision ? I want logical comments.

2
Contributors
1
Reply
3
Views
5 Years
Discussion Span
Last Post by arrgh
0

I got strange result from the command.

What do you mean by "strange"? What was the actual error message?

web application. I used MS Access as back-end database.

Honestly MS SQL would be a better choice. MS Access was designed for individuals to use on their desktops, not for web applications.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.