calculated field in a query

[Infinite]

This is not the normal calculated fields in query's. What I want is different, I want it to be like IFF(ShowID="A",[TotalSales],0) Thing I have is, I want to know all the Total sales in on row that has Show A in it and then Total sales for Show B. Problem is, I have over 130 shows. How would do that?

 

[KenHigg]

It would help to know exactly how you plan to use the numbers? In a report or a form?

 

[Infinite]

I was planing on it being a form.

 

[KenHigg]

Well, you could have it in an unbound textbox control using dsum() if the data set is not real large or if it needed it in a table seems one way would be to have a new query that summed sales by ShowIDaccount then link that back to the original query.

 

[Infinite]

well I have almost 140 shows, and 13130 sales.

 

[CJ_London]

investigate using a group by query

here is a link

http://www.tutorialspoint.com/sql/sql-group-by.htm

 

[Infinite]

CJ, went to that link and found exactly what I wanted! Thanks a TON man!