Adding a letter "m" after a calculated number to indicate length

  • Thread starter Thread starter mark909
  • Start date Start date
M

mark909

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!
 
How are you calculating the length? It should be as simply as adding

& "m"

after that.
 
Hi Douglas,

SumOfLength

Field : Length is calculated from Total: Sum in the design view for the query.

I cant get it to work...

Forgive me if its simple but im still getting the hang of access!!
 
Go into the SQL view. You should find

Sum(Total) As Length

somewhere in it. Change that to

Sum(Total) & "m" AS Length
 
Back
Top