Search results

Cheers pal! I appreciate it.

I have posted a copy for you.

When I linked the tables up it did not show anything within the select query. When I played around with it basically it came back with all the discounts for that product on Customer ID. If I posted a copy of my database, you couldn't take a look could at it could you?

Hi Bob, I did try that but it didn't seem to work. Not sure what I did wrong either. :confused:

Hi I am fairly new to Access and have been struggling all weekend to try and accomplish this task. I have been asked to create an orders database for purchase orders on certain products which is fine. However I have now been told that each customer will have they're own many discounts on...

Still getting nowehere with this. All I want is basically an employee selects custom name from Combo box, and produt, then an automatic discount is applied to that product. Just don't know how to get it to work correctly.:(

Hi Sorry its been really late. I have posted a copy of my Database though. Really hope you could help me out here, that would be fantastic.

I am really stuck on this to be honest. I have my tables and linked them up, however it is not displaying correctly, nor does it seem to be working too.:banghead:

I'm having some trouble getting this to work, I have an orders form and what I wish to do is when somebody creates an order with a company based on an item it automaticially gives them a discounted price on that product. I have a table within my database with an Account Number, SKU, and a...

I have been asked to create a database that creates orders, debits stock etc for my company. Now I have been asked to put in some kind of discount table with percentages for each individual item for each individual customer. What would the best way of doing this? I figured in the Customer...

Hi all I currently have =Sum([Extended Price]*1.2-[Extended Price]) however it is showing a price of 9.144, however I want it to just show 9.14. is it something to do with round?

Hi all I seem to be having some trouble with my unit price. Its not round up correctly. I currently have this : Extended Price: CCur(Nz([Quantity]+[QuantityToFollow],0)*[UnitPrice]*(1-[Discount])) which comes to £45.74, but the actually price should be £45.72. Its some how rounding up. I...

Thank you for doing this. I have however moved the query and form to display the message across to my main database and the Message does not seem to be appearing when I open up the database.

There is a table called Order Status, which is linked to my Orders Form. When a Item is picked it displays quantity left. You can then set the Order Status to Active, Back Order, Cancelled Refunded, Done. As for the VAT, this is a simple sum method based on the Sub Total values.

Worked like a charm!

I'm currently using 2007, A Back Order is when the item is out of stock and the Order Can still be placed, but I have included a status dropdown in my form so the user can Change Status from Active to Back Order. Ideally I would also like a message prompting the user if they have not given an...

Hi all, I currently have a dropdown menu with a list of products called ProductName that is updated with a price etc. That works fine, however When I come to create another combo box with ProductTitle, I cannot quite seem to get it to update the ProductName combo box. Basically a customer orders...

Good eveing all, I ahve 2 questions regarding Access and didn't know where to post. Firstly, we have an Orders DB that also includes Back Orders, when a user opens up the orders I wish to flag up an message about the remaining orders "You have X Back Order(s) left." I don't really know how to...

Adding Order Form Data into table I've posted a copy of my DB but yes the prices in the last four fields are SUMs based on the Subtotal (not including VAT). But for me to print out a Depatch Note and Invoice I need those prices stored in the orders table.

Would this help? http://www.youtube.com/watch?v=TB3Qp1pdNOY