Access template change

[Humbled Learner]

Good Morning,

I have downloaded the "orders management database" from
http://office.microsoft.com/en-us/templates/TC010185481033.aspx?CategoryID=CT101426031033

If someone could be so kind to view the example on the microsoft site, I
have a very simple request.

On the example shown, I need to move the PO Number field down between the
"product" and "quantity" columns. I can't get the information to the
subform. Maybe its a relationship problem or a query thing I don't
understand.

I'm fairly knowledgeable in access, worked on this for 2 straight days, even
bought the access for dummies book and I just don't get it.

If possible, could someone download that file, add the change and email
direct to (e-mail address removed)?


Any assistance is GREATLY appreciated.

Thank You
Bob

 

[Humbled Learner]

When I enter SQL and paste

SELECT [Order Details].OrderDetailID, [Order Details].OrderID, ProductID,
PurchaseOrderNumber, Quantity, UnitPrice, Discount, CCur(Nz([Quantity],0)*
[UnitPrice]*(1-[Discount])) AS [Extended Price]
FROM [Order Details] INNER JOIN Orders ON [Order Details].OrderID = Orders.
OrderID

I cannot save I and exit, get an error that says Syntax error in FROM clause.