Search results

ive got a table that stores all items ordered, which has custmer id, product id, cost, amount of item then the order table contains total price of the order, shipping options and selects card from payment table the basket is only temporary i run an append query once the order has been placed.

I wanted Basket total to go to SubTotal on tblOrders and at the same time CustID to tblOrders

Ive saved the info from the basket i need to, but is there a way i can take the value from Basket Total and put it into a field on another table?

..omg i love you :D thats awesome Thank you so much! (:

Its a mess at the moment really, just trying different things. Once ive worked out this problem i should be okay. thank you again!

Okay youve lost me :P If i join the 2 tables in a query and add them onto the basket form then when i click the drop down box it displays options but doesnt let me choose one, just gives error beep? the price is displayed straight away but only of the first item But the thing is i need to be...

I have relationships set up yes. The main form has tblCustomer the subform has tblBasket. tblBasket has CustID, ProductID (joint primary key) NoOfProduct, ProductCost, SubTotal When i add the items to the form i dont add CustID from basket just from the tblCustomer. I select which customer...

I'm not sure, but basically speaking all i want to do is display a price based on the currently selected ProductID? Whats the easiest way i can do that?

I have a lookup on a table that calls ProductID, ProductName and ProductCost from tblProducts. The lookup is on the field ProductID on tblBasket and when the item is selected it displays the correct value. However when the item is selected i need to take the ProductCost value from tblProducts...

Thank you so much for your help! means alot!

SELECT ram.RamID, ram.Ram, ram.RamCost FROM ram; SELECT proc.ProcID, proc.Proc, proc.ProcCost FROM [proc]; =(Proc.Column(2)+Ram.Column(2))

What do you mean by rowsource? sorry

Ok well damn close now, and i can offically say i love you! But at the moment when it adds 23 and 25 it puts 2325 any idea why this is? Thanks so much for the help!

Well i was going to make it so that it dropped down and was linked to 3 fields ProcID ProcName and ProcCost etc each one would be on a different table but all pulled in together with lookup fields calling all 3 in an orders table would that code you put be applicable?

no the page layout will be like this: You select all the compoants and it has to get the price for each one and make a total.

Well at the moment i'm still in the design stages, but i made a database with test fields to see how it would work out best. Basically i have to have a form with a drop down list for each type of computer componant and when selected the total price for all the items selected so far needs to...

Hello there, some help would be nice! Say i have a booking field. If people wanted to book a number of seats, how would i make it so that when the number of seats that was entered on the booking form was entered it would add on to the exsisting number of seats taken? So say for film A There is...