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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate % Length of one Criteria against % Length of other 4 Cri 2
Calculation Trouble 10
Summing different lengths and percentage split --------M--------- 2
How to adjust physical lengths of fields 5
Calculated Controls Nz IIf 7
Convert zero-length string or blank cell to null 3
Count field length in delimeted file and compare with predefined listof field length 8
Adding recognised Zeros 5

Back
Top