Format the Display of Numbers

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

Guest

I have created a linked database from information linked from a Juris
database. One field, the matter number, consists of 12 characters, i.e.
000000000001, depending on the number of matters associated to a particular
client file. Sometimes the number can be as high as 500, but never higher.
I would like the client number to display in my reports 3 character
positions, not the 12 positions.

How do I set the reports to display, 012 instead of 000000000012?

Thank you so much for your help.
 
JeanneJo said:
I have created a linked database from information linked from a Juris
database. One field, the matter number, consists of 12 characters,
i.e. 000000000001, depending on the number of matters associated to a
particular client file. Sometimes the number can be as high as 500,
but never higher. I would like the client number to display in my
reports 3 character positions, not the 12 positions.

How do I set the reports to display, 012 instead of 000000000012?

Thank you so much for your help.
Click to expand...

=Right(YourFieldName,3)
 
Thanks, Rick. I'm not getting the job done - keep getting an error when
attempting to implement your suggestion. I enter =Right([MatCode],3) and all
sorts of variations, all with the same result. Since the error references
Circular reference, I have attempted to rename things, along with turning off
the AutoCorrect feature, and am still getting the same error.

I'll keep working on it. It's something I'm doing, of course. Again,
thanks for your suggestion. I'm sure it works!
 
Did you change the name of your control from "MatCode" to something like
"txtMatCode"?
--
Duane Hookom
MS Access MVP

JeanneJo said:
Thanks, Rick. I'm not getting the job done - keep getting an error when
attempting to implement your suggestion. I enter =Right([MatCode],3) and
all
sorts of variations, all with the same result. Since the error references
Circular reference, I have attempted to rename things, along with turning
off
the AutoCorrect feature, and am still getting the same error.

I'll keep working on it. It's something I'm doing, of course. Again,
thanks for your suggestion. I'm sure it works!

Rick Brandt said:
=Right(YourFieldName,3)
Click to expand...
Click to expand...
 
JeanneJo,

Try this:

=Format([MatCode],"###")

Just might work.

Sam
Thanks, Rick. I'm not getting the job done - keep getting an error when
attempting to implement your suggestion. I enter =Right([MatCode],3) and all
sorts of variations, all with the same result. Since the error references
Circular reference, I have attempted to rename things, along with turning off
the AutoCorrect feature, and am still getting the same error.

I'll keep working on it. It's something I'm doing, of course. Again,
thanks for your suggestion. I'm sure it works!
[quoted text clipped - 8 lines]
=Right(YourFieldName,3)
Click to expand...
Click to expand...
 
Whew - I got it. I gave up trying to control it in the report and went back
to the query where I formatted the field MatCode - when I selected "build,"
it automatically changed the name to Expr1 - from there I did the
"=Right([MatCode],3) and IT WORKED!! Went back into the report and redefined
that field to see Expr1 and the report reflected the number scheme perfectly
as well.

Thanks all of you for your help. I don't work a lot in Access (obviously)
and every little data variance involves a lot of time getting things to work
as I want them to. This user group is a great help - again, thanks so much.

Jeanne.

OfficeDev18 via AccessMonster.com said:
JeanneJo,

Try this:

=Format([MatCode],"###")

Just might work.

Sam
Thanks, Rick. I'm not getting the job done - keep getting an error when
attempting to implement your suggestion. I enter =Right([MatCode],3) and all
sorts of variations, all with the same result. Since the error references
Circular reference, I have attempted to rename things, along with turning off
the AutoCorrect feature, and am still getting the same error.

I'll keep working on it. It's something I'm doing, of course. Again,
thanks for your suggestion. I'm sure it works!
I have created a linked database from information linked from a Juris
database. One field, the matter number, consists of 12 characters,
Click to expand...
[quoted text clipped - 8 lines]
=Right(YourFieldName,3)
Click to expand...
Click to expand...
Click to expand...
 
Next time change Expr1 to something that makes sense while designing your
report like
MatCode3: Right([MatCode],3)

--
Duane Hookom
MS Access MVP

JeanneJo said:
Whew - I got it. I gave up trying to control it in the report and went
back
to the query where I formatted the field MatCode - when I selected
"build,"
it automatically changed the name to Expr1 - from there I did the
"=Right([MatCode],3) and IT WORKED!! Went back into the report and
redefined
that field to see Expr1 and the report reflected the number scheme
perfectly
as well.

Thanks all of you for your help. I don't work a lot in Access (obviously)
and every little data variance involves a lot of time getting things to
work
as I want them to. This user group is a great help - again, thanks so
much.

Jeanne.

OfficeDev18 via AccessMonster.com said:
JeanneJo,

Try this:

=Format([MatCode],"###")

Just might work.

Sam
Thanks, Rick. I'm not getting the job done - keep getting an error when
attempting to implement your suggestion. I enter =Right([MatCode],3)
and all
sorts of variations, all with the same result. Since the error
references
Circular reference, I have attempted to rename things, along with
turning off
the AutoCorrect feature, and am still getting the same error.

I'll keep working on it. It's something I'm doing, of course. Again,
thanks for your suggestion. I'm sure it works!

I have created a linked database from information linked from a
Juris
database. One field, the matter number, consists of 12 characters,
[quoted text clipped - 8 lines]

=Right(YourFieldName,3)
Click to expand...
Click to expand...
Click to expand...
 
Back
Top