very basic question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm currently trying to learning Access, though I don't have a manual or anything so any help would be appreciated. (I've kind of just been thrown into this project with little support)

In access, I have a table with a list of names and their category codes. I need to count up how many entries are in each category.

In addition, i have a separate table that I imported from excel that contains the associated name for each code. I would like to somehow link these two tables together

Any help would be greatly appreciated. Thanks!
 
I'm currently trying to learning Access, though I don't have a manual or anything so any help would be appreciated. (I've kind of just been thrown into this project with little support).

In access, I have a table with a list of names and their category codes. I need to count up how many entries are in each category.
Click to expand...

Create a new Query based on the table; select the name and the
category code. Change it to a Totals query by clicking the Greek Sigma
icon - looks like a sideways M (or W). Leave the default Group By on
the Category field, and change it to Count on the Name field.
In addition, i have a separate table that I imported from excel that contains the associated name for each code. I would like to somehow link these two tables together.
Click to expand...

Just add this table to your Query; if it doesn't join them
automatically, drag the Category Code from this table to the Category
Code in the names table. Select the associated name from the new table
(and group by it too).
 
1. To count up how many entries are in a category make a query in design view. Add the table or tables needed to reference both the names and the categories. On your tool bar you should see a "Totals" button that will include the Total line on your query. To count the number of entries in each category simply change the category codes "Total" to "Count" in the drop down menu

2. To link the two tables together you should be able to add the separate table into the query in the very beginning. If there are any problems with this you may need to set up a relationship between the two.
 
Back
Top