HELP PLEASE! Missing info on invoice

Tech-Archive recommends: Speed Up your PC by fixing your registry

Following is the information for my Invoices and Packing Lists. For some
unknown reason, if I have more than 4 line items, line item 5 and 6 do not
display when printed. They also do not calculate in the total. However,
they do display on the screen.

This has me at a standstill. The only change I have made lately is to move
the Notes field into the detail area rather than the page footer where I did
have it.

Thank you.



SELECT Orders.*, [Order Details].OrderDetailID, [Order Details].ProductID,
Products.ProductCode, [Order Details].Quantity, [Order Details].UnitPrice,
Customers.CompanyName, Customers.ContactFirstName,
Customers.ContactLastName, Customers.BillingAddress, Customers.City,
Customers.StateOrProvince, Customers.PostalCode, Customers.[Country/Region],
Customers.PhoneNumber, Customers.PONumber, Customers.ContactFirstName & " "
& Customers.ContactLastName AS [Contact Name], [Shipping
Methods].ShippingMethod, Products.ProductName, [Order Details].LineItem,
[Order Details].SerialNum, Customers.ControlNum, Contracts.ContractNum,
Dealer.DealerName, [Order Details].Discount, [Order Details].Notes
FROM (Dealer RIGHT JOIN (Customers RIGHT JOIN ([Shipping Methods] RIGHT JOIN
(Employees RIGHT JOIN Orders ON Employees.EmployeeID = Orders.EmployeeID) ON
[Shipping Methods].ShippingMethodID = Orders.ShippingMethodID) ON
Customers.CustomerID = Orders.CustomerID) ON Dealer.DealerID =
Orders.DealerID) RIGHT JOIN ((Contracts INNER JOIN Products ON
Contracts.ContractID = Products.ContractID) INNER JOIN [Order Details] ON
Products.ProductID = [Order Details].ProductID) ON Orders.OrderID = [Order
Details].OrderID
WHERE (((Customers.ControlNum)=[Specify ControlNum]))
ORDER BY [Order Details].LineItem, Orders.ShipDate;


.

Relevant Pages

  • Re: Better "Join" vs "Where" clause?
    ... if you don't display any field from the second table when you are ... an INNER JOIN might give you the apparence that ... it appears that a WHERE clause accomplishes the same data set ...
    (microsoft.public.access.queries)
  • Re: Real dificult SP ... is it even possible ?
    ... > I have been thinking and thinking how to do this query, ... > many depending on the user selection. ... > I need to display on page two all cases in which the selected users are ... > Inner join users on cases.userid = users.userid ...
    (microsoft.public.sqlserver.programming)
  • Re: Can TRANSFORM be used in a Crosstab Query to show text
    ... If the content is a unique number I have used the TRANSFORM Sumto display the infomation but now I would like to display a text value. ...
    (microsoft.public.access.queries)
  • Re: Can TRANSFORM be used in a Crosstab Query to show text
    ... Vanderghast, Access MVP ... If the content is a unique number I have used the TRANSFORM ... Sumto display the infomation but now I would like to display a text ... FROM tblSiteColorCode INNER JOIN (tblHomeSite INNER JOIN (tblRACOMSystems ...
    (microsoft.public.access.queries)
  • Re: Need a dropdown list that holds the value
    ... down that when selected it can keep a value and display it below here ... A drop down list of different shipping methods. ... <!DOCTYPE html> ... Ive been going crazy trying to get something to ...
    (comp.lang.javascript)