ok so I'm making a database for my workplace... It is a small company and they don't have a huge stock but big enough. They recently wanted to start keeping track of specific computers as opposed to just groups of them (ie serials). So I'm just a little confused as to the best method to approach the total quantity of an item now... is there any way to use a query to count the number of in stock computers with serials or is there a much easier way?

For the record, I am practically falling asleep in my chair as I write this so if there are any completely bonehead statements I am blaming sleep deprivation ahead of time.

Thanks for any help in advance