Relatively New at Access, need report from Raw Data

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

Guest

Hi!

I have an Access Database with over 10,000 records. My objective is
tocreate a simple report that counts occurances from this raw data. For
example, I need to illustrate how many people from what area hit our website
based on region/IP address results we have.

The raw data is one table containing the IP address, name of User, and the
pages on the site they hit. What I would need is a (seemingly) simple report
of how many times the IP address came up. Beyond that, I can analyze the
report to find out which regions the IP address came from.

If anyone could give me steps to get this result I would be grateful.

Thank you in advance!
 
You would be looking at an Aggregate or "Totals" query. You can create one
in the Query Builder by clicking the button with the Sigma on it. For this
one, you'd want to GroupBy on IPAddress and then Count IPAddress. In SQL
View, it would look something like this:

SELECT IPAddress, Count(IPAddress) AS CountOfIPAddress
FROM MyTable
GROUP BY IPAddress

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Access reports are great if you want a standard "published" format. If you
want something more interactive and flexible and you are more interested in
"Raw Data", consider creating a pivot table in Excel. You can connect the
pivot table to your Access table.
 
Back
Top