Text with sum()

[Guest]

how can I add text to the =sum() funciton?

I have a function; =sum([field]) and want to add text to it, preferably in
front of the sum. e.g. "widgets 89"

It must not be the same as ="Printed " & Now(), to print "Printed [today's
date]"

tia

 

[David Phelan]

Try ="Widgets " & sum([field]) as the query expression.

 

[Guest]

Thanks for the reply.

I should have mentioned that this function is in an unbound control on a
form. I tried to use

="Widget" & sum([field])

and it just gave me "Widget", without any sum figure.

Any other thoughts?

ta
JMorrell

Try ="Widgets " & sum([field]) as the query expression.

how can I add text to the =sum() funciton?

I have a function; =sum([field]) and want to add text to it,
preferably in front of the sum. e.g. "widgets 89"

It must not be the same as ="Printed " & Now(), to print "Printed
[today's date]"

tia

 

[Pieter Wijnen]

hide the control with the =sum() (MySum)
make a new control with control source ="widget " & Forms!MyForm!MySum

hth
Pieter

Thanks for the reply.

I should have mentioned that this function is in an unbound control on a
form. I tried to use

="Widget" & sum([field])

and it just gave me "Widget", without any sum figure.

Any other thoughts?

ta
JMorrell

Try ="Widgets " & sum([field]) as the query expression.

how can I add text to the =sum() funciton?

I have a function; =sum([field]) and want to add text to it,
preferably in front of the sum. e.g. "widgets 89"

It must not be the same as ="Printed " & Now(), to print "Printed
[today's date]"

tia

 

[Guest]

What you gave me actually makes sense. But somehow in my report, it doesn't
work (like it would a =sum() in the footer section of a report). I get the
#Name? error.

What now?
ta,
JMorrell

hide the control with the =sum() (MySum)
make a new control with control source ="widget " & Forms!MyForm!MySum

hth
Pieter

Thanks for the reply.

I should have mentioned that this function is in an unbound control on a
form. I tried to use

="Widget" & sum([field])

and it just gave me "Widget", without any sum figure.

Any other thoughts?

ta
JMorrell

Try ="Widgets " & sum([field]) as the query expression.


how can I add text to the =sum() funciton?

I have a function; =sum([field]) and want to add text to it,
preferably in front of the sum. e.g. "widgets 89"

It must not be the same as ="Printed " & Now(), to print "Printed
[today's date]"

tia