Recent content by julsue13

Thanks guys - I guess that saying the truth lies somewhere in between really applies! Finally got it :)

Okay, so I finally figured out to just set this up in the SQL view... SELECT TOP 20 Count(Results.target_host_name_path) AS CountofFldname, FROM Results GROUP BY Results.target_host_name_path, ORDER BY CountOfFldname DESC; In the above code, does anyone know what parameters would apply to...

Okay, so I am currently putting all the fields into a query, then in the target_host_name_path field "criteria" I am adding the code: Select Top 20 count ( [Results]![target_host_name_path] ) as CountofFldname From Results Groupby [Results]![target_host_name_path] Orderby CountofFldname Desc...

Thank you for the response. I have a good idea of what I would like to do regarding the (Count, group by, order by, top) functions... but unfortunately am having issues figuring out the proper syntax. I have programming and SQL background, but unfortunately Access 2000 requires particular...

I have a table of data including a field defining name and path for defined users. I would like to count the occurrence of each text name/path in the field, and determine the top 10 or 20 occurrences. Then create a table of the top occurrences with all table fields included. Also, my current...