Inventory Database

[orange]

Create a query with your 2 tables. You have a relationship between them right -- Asset_type_code.

You don't want Sum, you want Count I think.
Try something like this as a query

SElect AssetTypes.Asset_type_desc, Count(IT_Assets.asset_type_code)
from AssetTypes,IT_Assets
where IT_Assets.asset_type_code = AssetTypes.asset_type_code
group by AssetTypes.Asset_type_desc

[roger556]

Hi Orange,
Attached you will find the mdb file of the database I am creating.Please if you can take a look at it and give your suggestions or advice it will be most welcomed.

Thanks,
Roger

[orange]

I have loaded your database and taken a quick look.
Field names, Table names, query names and any other object names should not have embedded spaces.
You should be working from a designed data model.
It would be a good practice to define all of your tables and fields -- not only for future reference and communications, but also because you will improve your understanding of your data and processes.

Here are a couple of links that will serve you well.
http://www.rogersaccesslibrary.com/forum/topic238.html Normalization ER Diagrams
http://www.accessmvp.com/strive4peace/ Access basics tutorials/reference
http://www.fontstuff.com/access/index.htm Marting green's tutorials with examples

Good luck