how to do a where query

  • Thread starter Thread starter Rivers
  • Start date Start date
R

Rivers

hi is it possible for me to do this:

where record says orange sum time
where record says apple sum time2
where record says banana sum tim3

in a query
 
Your question is about as vague as I have read. This should answer your
question based on the way it was asked:

SELECT Sum(Abs([Record]="Orange") * [Time]) as OrangeSum,
Sum(Abs([Record]="apple") * [Time2]) as AppleSum
Sum(Abs([Record]="banana") * [Tim3]) as BananaSum
FROM tblFruitTimes;

If you need more help, please provide actual table and field names and a
more complete requirement.
 
Back
Top