Frequent Data in Tables

  • Thread starter Thread starter amejr999
  • Start date Start date
A

amejr999

Hi everyone,

I'm working on a project, and I'm a bit confused about how to make a query.
I'm new to Access, so please forgive me if this is obvious. Basically, I
have a table containing a list of ID numbers and a list of names. Most of
the ID numbers of more than one name associated with them. What I'm trying
to find is how to create a list of the movies that are most highly
correlated. In other words, I'm looking for the names that are most often
listed together under the same ID numbers.

I'd very much appreciate any help that you could provide (but please make it
as simple as possible for my sake :) )

Thanks!
 
Sorry, I'm completely confused (told you I was new at this)! Just to
clarify, the field IDnumber is the first column of the table, and the field
favorite is the 2nd column (favorite is text, not numerical). The table is
named favorites.

I'm trying to run the following:

SELECT ID, favorite, COUNT(*) As CountOf
FROM favorites
GROUP BY ID, IDnumber
ORDER BY 3 DESC

but it's returning a message that "You have tried to execute a query that
does not include the specified expression "favorite" as part of an aggregate
function." I've played around with the query a bit, but it keeps returning a
similar message. Maybe part of the issue is that there is no 3rd column?

Any ideas? Thanks in advance.
 
Back
Top