creating reports from imported excel sheet

[rubber]

Hi, Am really new to access2010,
pls i have an excel data for assets and i have imported it into access 2010 but i want to be able to do the ffg;
1. want to be able to generate reports like how many computers does a particular branch have.
2. i want to be able to sum the no of each field heading per branch

would appreciate your response

 

[Pat Hartman]

You will need to build some queries to summarize the data. I can't help you much beyond that without a small sample of the data or at least a list of column names.

1. If each row in the sheet represents a single asset, a query similar to the following will give you a count of computers by branch.
Select Branch, Count(*) As ComputerCount
From YourTable
Where AssetType = "Computer"
Group by Branch;
2. I don't know what field headings are so I can't help with this one.