Negative results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query where in a field I have a results from several fields. I want
to know how to show the result if negative in ( ) and not with a -.

thanks
 
Dear Roger:

Use the Format function, somewhat like this:

Format(-12.34, "$#,##0.00;($#,##0.00)")

Read the online help for the Format function for details.

Tom Ellison
 
Roger

That sounds like one of the options you'd have if you checked on the Format
property of that field in the query definition...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I have a query where in a field I have a results from several fields. I want
to know how to show the result if negative in ( ) and not with a -.

thanks
Click to expand...

In Query Design view, right-click anywhere in the column (on the lower
pane).
Write:
#;(#);0
in the format property line.
Save the change.

See Access Help on
Format property + Number and currency datatype
 
Your field is called FRED

Iif([FRED]<0,"("&abs([FRED])&")",[Fred])
I have a query where in a field I have a results from several fields. I want
to know how to show the result if negative in ( ) and not with a -.

thanks
Click to expand...
Click to expand...

Hey, Wait a minute!
I'm NEVER less than 0. <g>

Fred
 
Dear Fred:

The code tests to see if you're still alive.

Tom Ellison


fredg said:
Your field is called FRED

Iif([FRED]<0,"("&abs([FRED])&")",[Fred])
I have a query where in a field I have a results from several fields. I
want
to know how to show the result if negative in ( ) and not with a -.

thanks
Click to expand...
Click to expand...

Hey, Wait a minute!
I'm NEVER less than 0. <g>

Fred
Click to expand...
 
Dear Fred:

The code tests to see if you're still alive.

Tom Ellison

fredg said:
Your field is called FRED

Iif([FRED]<0,"("&abs([FRED])&")",[Fred])

Roger wrote:
I have a query where in a field I have a results from several fields. I
want
to know how to show the result if negative in ( ) and not with a -.

thanks
Click to expand...

Hey, Wait a minute!
I'm NEVER less than 0. <g>

Fred
Click to expand...
Click to expand...

Oh! OK.
In that case shouldn't the expression be:

= Iif([FRED]<0,"("Call 911",[Fred]) :-)
 
Dear Fred,

Some of the finest coding I've ever seen. Nice chuckle, too!

Tom Ellison


fredg said:
Dear Fred:

The code tests to see if you're still alive.

Tom Ellison

fredg said:
On Wed, 26 Apr 2006 11:58:49 -0700, Phil wrote:

Your field is called FRED

Iif([FRED]<0,"("&abs([FRED])&")",[Fred])

Roger wrote:
I have a query where in a field I have a results from several fields.
I
want
to know how to show the result if negative in ( ) and not with a -.

thanks

Hey, Wait a minute!
I'm NEVER less than 0. <g>

Fred
Click to expand...
Click to expand...

Oh! OK.
In that case shouldn't the expression be:

= Iif([FRED]<0,"("Call 911",[Fred]) :-)
Click to expand...
 
Back
Top