=[Price per hour]*[Number of hours] delivers 0 in the column Sum total.

[Thomas L]

Hi there all experts

I have created a text box labeled price per hour to fill in:
Price per hour in my access form.

I have created a text box labeled number of hours to fill in:
Number of hours in my access form.

I have created a text box labeled Sum total with the code:
=[Price per hour]*[Number of hours]
When exporting from Access to Excel, everything works just fine but when I want to get external data into an Excel Form from that Access database it delivers 0 in the column Sum total.

[maximus]

Hello Thomas welcome to the Forum. My question is this is the TextBox u have mentioned in your post is an unbound text box that you are using to display =[Price per hour]*[Number of hours] on your form or it is bound to a field.

Solution:

I will illustrate with a small example suppose I have a simple table Table1 with the fields ID, Items, Quantity, Price.

Now I would like to make a form and would like a Textbox to reflect Quantity*Price on it.

I will make a Select Query with a calculative field Total. The Sql Syntax:

SELECT Table1.ID, Table1.Item, Table1.Quantity, Table1.Price, [Price]*[Quantity] AS Total
FROM Table1;

Now make this the Recordsource of your form. when you update the Quantity and Price Fields on your Form the Total Field is also updated, to transfer the data to excel you can just export the Query to Excel using the the export option.

[Thomas L]

Thank you very much for you help maximus.
Problem is now solved with you wisdom and my stubbornness