Thread: Adding a letter "m" after a calculated number to indicate length
View Single Post
  #2  
Old May 8th, 2009, 12:22 PM posted to microsoft.public.access
Douglas J. Steele[_3_]
external usenet poster
  
Posts: 3,143
Default Adding a letter "m" after a calculated number to indicate length
How are you calculating the length? It should be as simply as adding

& "m"

after that.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"mark909" wrote in message
...
I have a table with multiple fields including "Length"

Ive created a query to calculate the total of lengths according to the
project id.

However I was hoping that I could get an "m" after the calculated length
so
it will show up in a report as "1548m" for example.

Thanks for any help!