Data question...

[TSI01]

Hi there,

This might be off topic, but I have to columns in access, a client estimate value and a system return value.

I want to measure how far the system return value was from the estimate value expected from a client. How can I do this in an access report? or incorporate it in a report, other than using a line graph showing how far each value is from a threshold of 75%?

Help pls...

 

[Crowley16]

just include another field in your query which calculates this...

something like:

select estVal, rtnVal, rtnVal - estVal AS diff from tbl where...

although that assumes both fields to be numbers, if you, you'll have to convert them to numbers, check CINT...

--------------------
Procrastinate Now!

 

[PHV]

Something like this ?
SELECT [client estimate], [system return], Format(([system return]-[client estimate])/[client estimate],'percent') AS Diff
From yourTable

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TSI01]

Thanks a bunch, I will give it a shot.