is there a tutorial on how to insert products to OrderDetailT with the customers tax rate if the product is taxable, using an append query instead of using a combo box? I can already get it to work using the combo box (with the exception of the query calculated tax amount) but I don't want to use the combo box for one product at a time I am already able to insert all the products using the append query and I'm able to insert the "T" for when the product is taxable using IIF(IsTaxable,"T","") in the append query
I'm not exactly following what you're trying to do. Are you saying that the products are already added to the order, and you want to run an append query to update them all?
John GemayelOP
@Reply 2 years ago
i figured out. I built an sql using an append query to drop products onto an order from another form rather than a combo box.
John GemayelOP
@Reply 2 years ago
Append query was overriding the customer discount and sales tax rate default value on the order detail query
Glad you figured it out. It's tough to tell you what to do without having a broader view of how your database is set up and what you're doing. If you're not working with one of my databases, then I need a lot more info - screen shots, etc.
John GemayelOP
@Reply 2 years ago
yeah it's not easy especially the way I explain. I think the append query was actually overriding the customers sales tax and discount rate default values in the orderdetail form (not query) but now it won't calculate the total on non taxable products due to the null value. Nz doesnt work in the append query for sales tax rate
John GemayelOP
@Reply 2 years ago
John GemayelOP
@Reply 2 years ago
don't worry about this. I figured it out. Thanks Richard
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 4.
