I've set up a SQL in this way(shows like bellow), But the Group Clause doesn't work to the second field(expense.expense_type). I've test several times, but it still doesn't work. Pls give me a hand. Thanks!:)
SQL STATEMENT:
Select Expense.Employee_Expense_ID AS Expense_ID,Employee_Name,0.00 AS Deposit_Amount,Expense.Expense_Type AS Expense_Type,Expense.Expense_Date,SUM(Medic_Amount) AS Medic_Amount,0.00 AS Expense_Amount,0.00 AS Self_Paid,ExpenseBill.Expense_Type AS BillType,SUM(Bill_Pages) AS Bill_Pages,Bill_Date,COUNT(*);
From Expense,ExpenseBill,EmployeeBaseINFO;
Where Alltrim(Expense.Unique_ID)==Alltrim(ExpenseBill.Unique_ID) And Alltrim(EmployeeBaseINFO.Employee_Expense_ID)==Alltrim(Expense.Employee_Expense_ID) And Expense.Expense_Date>={^2001-03-21} And Expense.Expense_Date<={^2001-03-26};
Order By Expense.Employee_Expense_ID,Expense.Expense_Date,Expense.Expense_Type,ExpenseBill.Expense_Type,ExpenseBill.Bill_Date;
Group By Expense.Employee_Expense_ID,Expense.Expense_Type