How to format a number in a textbox combined with text?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to get an answer how to combine a nr. field and a textstring in a
textbox inside a report (Access 2002)
What I like to do:
Ex:
I have a number that is 50000 this is imported from a tabel. When this is
showed in the report I would like to show this like this: 50.000 Bread are
delivered

I have tried this textstring and changed the format, but I cant make it
=[NrOfBread] & " Bread are delivered"

How can I make it?

Morten A.
 
Morten said:
I need to get an answer how to combine a nr. field and a textstring in a
textbox inside a report (Access 2002)
What I like to do:
Ex:
I have a number that is 50000 this is imported from a tabel. When this is
showed in the report I would like to show this like this: 50.000 Bread are
delivered

I have tried this textstring and changed the format, but I cant make it
=[NrOfBread] & " Bread are delivered"
Click to expand...


=Format(NrOfBread, "#,##0") & " Bread are delivered"
 
After a talk with a friend this morning. We found a way to do it.!! Thanks
for your answer anyway!!!

=Formatnumber([NrOfBread];0;0;0;-1) & " Bread are delivered"
--
Morten A.


Marshall Barton skrev:
Morten said:
I need to get an answer how to combine a nr. field and a textstring in a
textbox inside a report (Access 2002)
What I like to do:
Ex:
I have a number that is 50000 this is imported from a tabel. When this is
showed in the report I would like to show this like this: 50.000 Bread are
delivered

I have tried this textstring and changed the format, but I cant make it
=[NrOfBread] & " Bread are delivered"
Click to expand...


=Format(NrOfBread, "#,##0") & " Bread are delivered"
Click to expand...
 
Back
Top