Data in a table in access

[gmazza76]

Good Afternoon,

I am new to access and could do with being pointed in the right direction. My query is?

I have a database already created, but would like a "Front Page" to open instead of the raw data. I could do with being pointed in the right direction as i would like to put names on the "Front Page" and tyhe data be added up into numbers.
ie.

Gavin Mazza 6
John Jones 10

Thanks
Gav

 

[Darren Bartrup]

Hi Gavin,

You need to look into queries and forms and/or reports.

The query will perform the calculations you want and the form and/or report will display the results in any format you choose.

So if your table has 2 columns, the first has your names and the second has the numbers. You'd create an SQL query something like

SELECT MyNames, SUM(Numbers) AS Total
         FROM MyTable
         GROUP BY MyNames

The query will result in a table with two columns called MyNames and Total - I've created the table using SQL rather than the GUI as it's easy to show on here. You can then use the form or report wizard to display the results of the query (or create a blank form and do it yourself).