HELP PLEASE! Missing info on invoice

[JNana]

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;

 

[Larry Linson]

It'd be a lot easier to help you if you tell us what data you have, how your
tables are laid out, and what your report contains. You have the advantage
of having the information available to you, but you have to describe it to
us.

If "Notes" are part of the detail records (line items?), then that's where
they belong. If they are at some other "level," putting them in Detail would
be redundant. It's hard for me to envision a data structure that would
contain Notes that really belongs on a Page Footer, unless they really are
"overall" notes that you want handy to the reader on each page.

Larry Linson
Microsoft Access MVP

 

[JNana]

My apologies. I "assumed" you could tell by the SQL view.

I have an Order Entry Database. I am using Windows XP, Access 2003.

I have a Customer Order Form and a subform - Order Details.

The Order Details contains: line item, product code, product description,
quantity, unit price, extended price, serial number and a notes field. The
notes field is an unbound field.

I have created Bill of Lading, Packing List, and Invoice reports using
the above information.

I noticed that when entering information in the note field, only the first
line item was visible on the reports. With the help of one of the microsoft
responders, I found that the notes field was in the page footer and should
be in the details section. I deleted it from the footer and moved it to the
page section. I made no other changes. Now everything is visible on the
Order Details subform; however, when I view any of the above reports, items
5 and 6 are missing. My secretary did the following: Deleted line items 5
and 6 and reentered. Then they were visible as well as printing - but not
in numerical order; ie. 1, 2, 3, 6, 4, 5.

I can look at orders entered prior to my moving the notes field and they
print okay. I cannot see anything in the forms or reports that would omit
line items 5 and 6.

Any suggestions? If you need more information, please advise. Thanks in
advance.

It'd be a lot easier to help you if you tell us what data you have, how your
tables are laid out, and what your report contains. You have the advantage
of having the information available to you, but you have to describe it to
us.

If "Notes" are part of the detail records (line items?), then that's where
they belong. If they are at some other "level," putting them in Detail would
be redundant. It's hard for me to envision a data structure that would
contain Notes that really belongs on a Page Footer, unless they really are
"overall" notes that you want handy to the reader on each page.

Larry Linson
Microsoft Access MVP

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;

 

[JNana]

I have made a temporary "Fix" to the problem. By process of elimination, I
have determined that the problem is coming from the Contract and the SIN
tables. If I delete these tables from the SQL query, the information
displays and prints correctly. Now I have to find out how to get those back
into the report.

Can you see any reason why this would happen?

It'd be a lot easier to help you if you tell us what data you have, how your
tables are laid out, and what your report contains. You have the advantage
of having the information available to you, but you have to describe it to
us.

If "Notes" are part of the detail records (line items?), then that's where
they belong. If they are at some other "level," putting them in Detail would
be redundant. It's hard for me to envision a data structure that would
contain Notes that really belongs on a Page Footer, unless they really are
"overall" notes that you want handy to the reader on each page.

Larry Linson
Microsoft Access MVP

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;