Format([myfield], "#.##")

  • Thread starter Thread starter fergie
  • Start date Start date
F

fergie

I converted a 97 version db to XP version db. One some
machines my query with a calculated field to format will
not work. Any ideas?

mycalfield: iif([abc]>7,[format([abc],"#.##"),0)
 
Is this a typo:

mycalfield: iif([abc]>7,[format([abc],"#.##"),0)

You have a square bracket to the left of format; delete that bracket.
 
no i did a typo in my message. The query field worked
for 5 years. This stopped working on some machines when
I converted it to XP.

-----Original Message-----
Is this a typo:

mycalfield: iif([abc]>7,[format([abc],"#.##"),0)

You have a square bracket to the left of format; delete that bracket.

--
Ken Snell
<MS ACCESS MVP>

I converted a 97 version db to XP version db. One some
machines my query with a calculated field to format will
not work. Any ideas?

mycalfield: iif([abc]>7,[format([abc],"#.##"),0)
Click to expand...


.
Click to expand...
 
Likely to be Reference Errors in your database. See Douglas J. Steele's
article:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

--
HTH
Van T. Dinh
MVP (Access)



no i did a typo in my message. The query field worked
for 5 years. This stopped working on some machines when
I converted it to XP.

-----Original Message-----
Is this a typo:

mycalfield: iif([abc]>7,[format([abc],"#.##"),0)

You have a square bracket to the left of format; delete that bracket.

--
Ken Snell
<MS ACCESS MVP>

I converted a 97 version db to XP version db. One some
machines my query with a calculated field to format will
not work. Any ideas?

mycalfield: iif([abc]>7,[format([abc],"#.##"),0)
Click to expand...


.
Click to expand...
Click to expand...
 
Hi,


You may have a missing reference: Tools | References... one of the
checked reference, on the PC where it is not working, probably starts its
description with the word MISSING. Uncheck it.



Hoping it may help,
Vanderghast, Access MVP


no i did a typo in my message. The query field worked
for 5 years. This stopped working on some machines when
I converted it to XP.

-----Original Message-----
Is this a typo:

mycalfield: iif([abc]>7,[format([abc],"#.##"),0)

You have a square bracket to the left of format; delete that bracket.

--
Ken Snell
<MS ACCESS MVP>

I converted a 97 version db to XP version db. One some
machines my query with a calculated field to format will
not work. Any ideas?

mycalfield: iif([abc]>7,[format([abc],"#.##"),0)
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top