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

[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)

 

[Ken Snell]

Is this a typo:

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

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

 

[Guest]

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)

.

 

[Van T. Dinh]

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)

.

 

[Michel Walsh]

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)

.