View Single Post
  #5 (permalink)  
Old June 6th, 2006, 07:37 AM
ebburks ebburks is offline
Authorized User
 
Join Date: May 2006
Location: Elk Grove, CA, USA.
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am just trying to show a total value of a certain type. Kind of like an inventory of how many of one type that there are in the db.
My query looks like this:

SELECT Sum([TotalCount]) AS Total
FROM [Ticket Inventory]
WHERE ((([Ticket Inventory].TicketType)="607"));

EB
Reply With Quote