Hi all
Need some help maybe I'm silly but I dont get this
I have a query the fields are

field: mydate warranttype returns
table: tblwarrant tblwarrant tblwarrant
total: group by groupby sum

criteria in the mydate field is

Between CDate("1/7/" & IIf(Month(Date())<7,Year(Date())-1,Year(Date()))) And CDate("30/6/" & IIf(Month(Date())<7,Year(Date()),Year(Date())+1))

which only bring out records in the fiscal year 1/7/2001 to 30/6/2002

when i run the query
it returns

mydate warranttype sumofreturns
1/7/2001 Paid in full 30
13/1/2002 Paid in full 15
15/1/2002 Paid in full 2
30/6/2002 Paid in full 30

MY question is how do I get the query to return
Paid in full 77
on one line?
On the report I require just the one line Paid in full = 77

I need this answer desperately thanks

Drop the colomn mydate in your query.

RV

If you uncheck the checkbox of the mydate field, you can enter criteria but prevent the mydate field from being included in the select clause.