> This should work out OK if you remove the inconsistent table
> identifiers. Either use all identifiers (OK but unnecessary for a
> single-table spec) or none.
>
> SELECT OrderType, F_DayOfWeek(OrderDate) As DayOfWeek,
> F_CDOWShort(OrderDate) As DayOfWeekName,
> Sum(OrderSub) AS TotalSales,
> OrderDate
> FROM OrdersPermanent
> GROUP BY OrderType, OrderDate;
>
> or (unnecessary)
>
> SELECT OrdersPermanent.OrderType, F_DayOfWeek

(OrdersPermanent.OrderDate) As

> DayOfWeek,
> F_CDOWShort(OrdersPermanent.OrderDate) As DayOfWeekName,
> Sum(OrdersPermanent.OrderSub) AS TotalSales,
> OrdersPermanent.OrderDate
> FROM
> OrdersPermanent GROUP BY OrdersPermanent.OrderType,
> OrdersPermanent.OrderDate;
>
> Fb 1.5 is a lot more fussy about grouping. If OrderDate is a

Timestamp,

> this might not work. In that case, try this instead:
>
> GROUP BY OrderType, F_DayOfWeek(OrderDate)
>

Thanks for replying , Helen. Tried all 3 suggestions and none
worked. Tried:

All table identifiers.
No table indentifiers.
Wraping F_DayOfWeek(OrderDate) in GROUP BY.
Took out the OrderDate from the GROUP By.
Tried it in a Boat.
Tried it with a goat.
Tried it, oh I've tried it, even in a moat.

Here is the table def:
CREATE TABLE ORDERSPERMANENT (
ALCOHOLTAX NUMERIC(15,4),
AMOUNTTENDERED NUMERIC(15,4),
AMOUNTTENDERED2 NUMERIC(15,4),
AMUSEMENTTAX NUMERIC(15,4),
CHANGEDUE NUMERIC(15,4),
CREDITTYPE VARCHAR(50),
CREDITTIP NUMERIC(15,4),
COMMENTS VARCHAR(50),
CUSTOMERPHONE VARCHAR(50),
DRAWERNUMBER INTEGER,
DRIVERID INTEGER,
LOCALSALESTAX NUMERIC(15,4),
NUMBEROFGUESTS SMALLINT,
ORDERCLOSED SMALLINT,
ORDERDATE DATE,
ORDERID INTEGER,
ORDERSTATUS VARCHAR(50),
ORDERSUB NUMERIC(15,4),
ORDERTIME DATE,
ORDERTOTAL NUMERIC(15,4),
ORDERTYPE VARCHAR(50),
PAYMENTTYPE VARCHAR(50),
PAYMENTTYPE2 VARCHAR(50),
PRINTED SMALLINT,
REMOTED SMALLINT,
SALESTAX NUMERIC(15,4),
SERVERID INTEGER,
STATIONID INTEGER,
STORENUMBER INTEGER,
STRAUTH VARCHAR(200),
TABLEID INTEGER,
TIMEOUT DATE,
TOTALTIME DOUBLE PRECISION,
VOIDMANAGER INTEGER,
SUPRESSORDERUPDATE SMALLINT,
FINALIZED SMALLINT,
SHIFTNUMBER SMALLINT,
ISOPEN SMALLINT,
ORDERDESTINATION VARCHAR(50),
EXTORDERID BLANKINTEGER,
VIPID BLANKINTEGER,
PERMID BLANKINTEGER,
RSTATUS RECORDSTATUS
);