No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
3 Posted Topics
[QUOTE=shanewaj;476182]I am having a complicated problem with the design of a database. Lets Describe the problem This is going to be used in a job tracking system we will have a list of jobs so TABLE 1: JOBS ([U]JOBID[/U],DUE DATE, SHIP DATE, INVOICE DATE, STATUS, CATAGORY) what is category well …
Same comment here - sum the fields when you retrieve the data, but don't store the sum in the table. [quote=nazihosseinioun;248702]If I want my database to be in 3nf,if i add a field which is the sum of 20 fields or not.[/quote]
There's no reason to add a field to round the total amount - you don't really want to store it in the table. What you need to do is to round the amount in the query you use to retrieve the data. That way you get the rounded value you …
The End.