Can I have a calculated field in a table?

[shaunacol]

I would like to work out a salespersons personal best GP total (£) and store it in a field in a table - is that possible?

I know that the following query SQL brings back the highest GP for a person but I cant get that to work within a table (probably because I dont really know where to put it!)

SELECT First(CommHistory.TotalGP) AS BestGP, CommHistory.SAlesPersonID FROM CommHistory GROUP BY SalesPersonID ORDER BY First(CommHistory.TotalGP), CommHistory.SalesPersonID;

 

[fneily]

Yes, it is possible. But bad table design. You don't store calculated fields in tables because it's against normalization. Here's a beginner course on normalization:
Fundamentals of Relational Database Design

http://r937.com/relational.html

 

[shaunacol]

I suppose it is bad practise but I want to store a field called Personal Best GP and do not really want to have the staff change that every time someon gets a new personal best. I suppose I will have to calculate it in a query but I tried that and it made it really hard to do some of the other things I was trying to do....

 

[SkipVought]

I suppose I will have to calculate it in a query but I tried that and it made it really hard to do some of the other things I was trying to do....

Maybe you could explain what was made really hard when you produced First(CommHistory.TotalGP) AS BestGP in a query?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]