Calculating and showing a negative number

[KC*3]

Hi there everyone!

I need to figure out how to show the diffence between 2 numbers.

Example:

Hours BID = 50.00 hours
Hours Used = 53.00 hours
Difference = -(3.00) hours
% of hours BID = -(6%)

If at all possible I'd like the negative numbers to appear in a Red font too. But that is not crucial at this point.

I'd also like to know how to do this for dates.

Example:
APP Task Completion: 10/3/05
CORD Task Completion: 10/1/05
Difference = -(2) days

If any of you know how to do this that would be so great! Thanks.

 

[nbrcrunch]

Please forgive me if my reply seems insulting. (You must be asking for something more than a simple subtraction formula but I don't know what that might be).

since you didn't indicate cells, the formula in English is:
=Used-Bid (For the difference)
=Used/Bid (for percent)

Same idea for your days calc

 

[Norie]

nbrcrunch is almost right.

I think you want the following expressions.

[Hours BID]-[Hours Used]

([Hours BID]-[Hours Used])/[Hours BID]

To get the required formats use Format(<expression>, <format>)

As for the dates you could just subtract one from the other, but I'm a little bit unclear what you mean by negative days.

 

[KC*3]

Totally not insulting because I should have been more specific. I do know the calculation and entering that in to the query is not a problem.

The real issue is when it comes to showing that it is a negative number. I have not been able to find a way to get access to show this as negative, it still shows as positive numbers.

Sorry for my confusion ; )

Katrina

 

[KC*3]

The negative days is only meant to say that the first task listed was completed after the second task listed. So I would want to show the interval as -2 days.

Katrina

 

[Norie]

Katrina

If the result of the calculation is negative then Access should show it like that.

If you are referring to the () then you would need to do some formatting for that.