If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form Problem
I need some help here. I have used the MS Office Template “Orders
Management” and made some minor changes to the tables. I am having some problems with my calculation fields. My order subtotal box gets the following error msg: “#Name?”. In my order total box I get the following: “#Error”. Also, My Orders Summary comes up with a error and I believe this is the root of the problem but can’t seem to figure it out. When I click on the Orders Summary I get the Enter Parameter Value box and has “Order Details Totals.OrderID and then the blank box. If I just hit O.K. it brings up the Query Table view. When I try to switch to Design View it says the following: MS Access can’t represent the join expression [Order Details Totals].OrderID=Orders.OrderID in design view. My tables are as follows: Order Details: Order Detail ID Order ID Nomenclature ID Part Number Quantity Unit Price Orders: Order ID Customer ID Employee ID Order Date PO Number Ship Date Shipping Method Taxes Comments My Queries: Order Details Extended: Order Detail ID Order ID Nomenclature ID Part Number Quantity Unit Price Subtotal In Design view I have the following: Subtotal: CCur(Nz([Quantity]*[Unit Price])) Order Details Totals: Order ID Line Item Totals In Design View I have the following: Line Item Totals: Subtotal and then the Sum Command Orders Summary Order ID Line Item Totals Order Totals Customer ID Employee ID Order Date PO Number Ship Date Shipping Method ID Comments This is the code behind the Orders Summary: SELECT Orders.OrderID, [Order Details Totals].[Line Item Totals], Nz([Line Item Totals])+Nz([Taxes]) AS [Order Totals], Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.PurchaseOrderNumber, Orders.ShipDate, Orders.ShippingMethodID, Orders.Comment FROM [Order Details Totals] INNER JOIN Orders ON [Order Details Totals].OrderID=Orders.OrderID; Forms: Main Form has the Orders Table as the Record Source Subform has the Order Detail Subform as the Record Source The Order Details Subform has the following: Nomenclature Part Number Quantity Unit Price. In the footer of my subform I have the following: =Nz(Sum([Subtotal]),0) I want to add calculations to the bottom of the form to add the order totals, tax, etc. In this order subtotal box I have the following: =[Order Details Subform].[Form]![txtOrderDetailsTotal] In the order total box I have the following: =[txtOrderSubtotal]+Nz([FreightCharge])+Nz([Taxes]) I would appreciate any help you can give me. I am fairly new to Access and just trying to get this to work for me. Also I am using MS Access 2007. Thanks |
#2
|
|||
|
|||
Form Problem
On Apr 24, 11:16*am, Nancy wrote:
*When I try to switch to Design View *it says the following: MS Access cant represent the join expression [Order Details Totals].OrderID=Orders.OrderID in design view. * My tables are as follows: Order Details: * * * * * * * * * * * * *Order Detail ID Order ID Orders: * * * * * * * * * * * * Order ID My Queries: * * Order Details Extended: Order Detail ID Order ID Nomenclature ID Part Number Quantity Unit Price Subtotal * * * * * * * * In Design view I have the following: * * * * Subtotal: CCur(Nz([Quantity]*[Unit Price])) Order Details Totals: * * * * * Order ID Line Item Totals * * * * * * * * * * * * * * * * In Design View I have the following: Line Item Totals: Subtotal and then the Sum Command Orders Summary * * * * *Order ID SELECT Orders.OrderID, [Order Details Totals].[Line Item Totals], Nz([Line I would appreciate any help you can give me. *I am fairly new to Access and just trying *to get this to work for me. *Also I am using MS Access 2007. * Thanks You have Oder ID and OrderID references. Pick one and change all of the other ones to the one you picked. |
Thread Tools | |
Display Modes | |
|
|