Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts
    can you help me find the error called missing operator Format([InvoiceDate],''mmmm''), in the folowing code:

    SELECT Format([InvoiceDate],''mmmm'') AS MonthName, DatePart(''m'',[invoicedate]) AS MonthNumber, Sum([order details].liters) AS SumOfLiters, customers.SegmentID, customers.TypeID Segments.segment, Types.Type
    FROM Types INNER JOIN (Segments INNER JOIN ((customers INNER JOIN orders ON (customers.Customerid = orders.customerid) AND (customers.Customerid = orders.customerid)) INNER JOIN (products INNER JOIN [order details] ON (products.Productid = [order details].ProductID) AND (products.Productid = [order details].ProductID)) ON orders.orderid = [order details].OrderID) ON Segments.SegmentID = customers.SegmentID) ON Types.TypeID = customers.TypeID
    WHERE (((Year([invoicedate])) = 2009) And ((orders.paymentid) = True))
    GROUP BY Format([InvoiceDate],''mmmm''), DatePart(''m'',[invoicedate]), customers.SegmentID, customers.TypeID, Segments.segment, Types.Type;

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I'd have to see a stripped down and zipped copy of the database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •