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!!
"Douglas J. Steele" wrote:
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!