multiply a text box on a report times a dollar amount

G

gbpg

I have a report that adds up the values of a number of fields. I want to
multiply the value in this text box time a dollar amount

I am trying to do this throught the control source with no luck. Any ideas
 
P

paul

text box?If you link your text box to a cell by clicking in the text box and
type =(say)A2,you can reflect what ever A2 shows in your text box
 
R

Roger Govier

Hi

If the times are in Excel times e.g 7:00 for 7 hours, then you will need to
multiply hours x 24 x rate.
Excel stores its times as fractions of a day, hence the need to multiply
by24.
 

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

Top