Results 1 to 2 of 2
  1. #1
    jordanturner is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Sep 2010
    Location
    Burnley, England
    Posts
    32

    Purchase Order Report

    Hello,



    I am having real problems understanding why my purchase order form will not preview as a report. Well the form will preview on the report but only after certain fields have been entered.n The form has all the normal fields a PO would have. It has a sub table for different order lines. In the sub table the fields are :

    transactionID, transactionTypeID, unitPrice, quantityOrdered, quantityReceived,
    dateReceived, receivedBy.

    The purchase order will not preview the order onto the report until the last field- receivedBy(combobox) is entered. The problem with that is when ordering, the company will only initially fill out the ordering fields until the order arrives as a delivery, then they will come back to the form and fill out the received fields.

    The receivedBy field is a combo box that will show different employee names and looks like this:

    SELECT [tblEmployees].[EmployeeID], [tblEmployees].[Forename], [tblEmployees].[Surname] FROM tblEmployees;


    The SQL for the report that previews the order looks like this:


    SELECT tblPurchaseOrder.*, tblInventoryTransactions.QuantityOrdered, tblInventoryTransactions.UnitPrice, tblStock.ItemName, Nz([tblInventoryTransactions].UnitPrice)*Nz([QuantityOrdered]) AS Subtotal, tblSupplier.CompanyName, tblEmployees.EmployeeID, tblEmployees.Forename, tblEmployees.Surname
    FROM tblSupplier INNER JOIN (tblStock INNER JOIN (tblPurchaseOrder INNER JOIN (tblEmployees INNER JOIN tblInventoryTransactions ON tblEmployees.EmployeeID = tblInventoryTransactions.EmployeeID) ON tblPurchaseOrder.PurchaseOrderID = tblInventoryTransactions.PurchasesOrderID) ON tblStock.StockID = tblInventoryTransactions.StockID) ON tblSupplier.SupplierID = tblPurchaseOrder.SupplierID;


    Any ideas for help on this will be greatly appreciated and I am sure it is something really small and simple but has been annoying me for a couple of days now.

    Thank you

  2. #2
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    Sounds like a join issue. Change the join to only include match employee records. See if that works.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. how to creat purchase order
    By arctushar@yahoo.com in forum Access
    Replies: 5
    Last Post: 10-07-2010, 08:14 PM
  2. Purchase Order Preview Problems
    By jordanturner in forum Forms
    Replies: 5
    Last Post: 10-03-2010, 10:10 AM
  3. Northwind Purchase Order Number
    By jpl85716 in forum Access
    Replies: 3
    Last Post: 09-29-2010, 12:53 PM
  4. Help With Purchase Order Form
    By SpeedyApocalypse in forum Forms
    Replies: 29
    Last Post: 04-09-2010, 07:06 PM
  5. Replies: 0
    Last Post: 12-11-2006, 04:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums