Search results

I am calculating the total sales using the formula, in a new field; Total Sales: ([Quantity]*[Price])+[postage] This works fine and adds up the totals of each individual sale. But, what I really want to show is the grand total of all sales (the total of all figures in the new "Total Sales"...

Thank you again! It now works perfect. Looking at the formula you gave it seems so obvious, I must have tried everything alse but that, think I forgot the () as well. I Very much appreciate all your help, Graeme

Hi, I have four fields; Quantity - Price - Postage - Total. In Control Source I already have the calculation in the TotalField... =[Price]+[Postage] and that works fine when the quantity is 1 But I need the Price to double when the Quantity changes to 2 I tried =[Quantity]*[Price] in a new...

Hi, that was exactly what I meant, sorry if that is not the proper term for it. I have'nt used the _AfterUpdate () before but your post was very easy to understand. I had a play about with it and (eventually!) got it to work!! This is great!, this will make the input of the form so much...

Hi, On text box properties, Format tab, Format box I type 'greater than' (>) symbol to get CAPS text or (<) for lower text. What I really want is Title text, is there a symbol for this? Thank you

You know I never even saw that forum category earlier but that looks just what I was needing, I'll go have an extensive search in there, thanks alot

Is there a web site that has examples of databases to search through to give planning ideas? I've offered to help a friend out :eek: , designing a database which will record all the customers/sales for her small online business. It would be a real help for me to see if there is a 'template' if...