Re: HELP PLEASE! Missing info on invoice

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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?


"Larry Linson" <bouncer@xxxxxxxxxxxxx> wrote in message
news:%23Ie4DtToGHA.4124@xxxxxxxxxxxxxxxxxxxxxxx
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" <jwrose@xxxxxxxx> wrote in message
news:%23yyyBKRoGHA.4108@xxxxxxxxxxxxxxxxxxxxxxx
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: dcount in query
    ... Services.ContractID) INNER JOIN Main ON Contracts.ClientID = Main.ClientID ... contract, in the Services table, with a Render value of No (that service was ... *not* rendered for this contract?). ... field in the Totals query - that will return each record in the Services ...
    (microsoft.public.access.queries)
  • Help woth stored procedure!
    ... Below is my stored procedure, for some reason it is not bringing back the ... max contract start date although I have sopecified this. ... dbo.tbl_referral_info.ri_ra_id INNER JOIN ...
    (microsoft.public.sqlserver.programming)
  • Conditional Counts in Textbox Controls
    ... The query data source ... SELECT CONTRACTS.CONTRACT_NUMBER AS CONTRACT, FISCAL_YEARS.FISCAL_YEAR ... FROM SALE_TYPES INNER JOIN (CUSTOMERS INNER JOIN ((CONTRACTS INNER ...
    (microsoft.public.access.reports)
  • Re: Page numbering
    ... This will open the header pane for editing. ... Click on the "Switch Between Header and Footer" button on the Header and Footer toolbar to access the footer. ... cover sheet and the 2nd and 3rd sheets are the contract, ... contract even though the contract itself is only 2 pages total. ...
    (microsoft.public.word.pagelayout)
  • Re: Script problem
    ... I would start by checking that the contract numbers that show up in ... assetdisp for the given dates are indeed in all tables being joined. ... asset.INNER JOIN lease on lease.= ...
    (microsoft.public.sqlserver.programming)