Simple Report Format Question

[Steve_Bache]

Hi - can you help with a simple question from a newbie ? How do I truncate an output field to display the last n digits of a 10 digit field ?

Thanks

Steve

 

[RichO]

=Right$([MyField],n)

 

[Steve_Bache]

Report Query

RichO

Cheers

Steve

 

[InDFW]

Where do you put this "=Right$([MyField],n)"

I want to eliminate the first 7 characters of a field. Would that be:
=Left$([MyField],7)

Where do I put this info? Somewhere in properties?

 

[RichO]

Left$([MyField], 7) would keep only the first 7 characters...

If you want to eliminate the first 7 characters:

=Mid$([MyField], 8)

If you are displaying this in a text box, you put it in the control source property of the text box.

Good luck

 

[InDFW]

thank you!
when i put it in the control source, it gave me an error, so i created a column in the query and did this:

NewName: Mid$([MyField],8)