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

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!
 
D

Douglas J. Steele

How are you calculating the length? It should be as simply as adding

& "m"

after that.
 
M

mark909

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!!
 
D

Douglas J. Steele

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
Access MSACCESS - Sorting report based on field calculated in the report 0
How To Update Access After Adding A New Field? 9
Adding columns in a table / fields in form 3
multiple counts, same calculated field, different parameters 6
Problem with Calculated Control in Report 2
Problem with Query 1
Problems adding a calculated field to an existing dataset. 3

Top