Log filter

[gream0604]

Hi all,

I really need some help if possible.

The database i have written filters a internet log file each month. The fields are as follows: Date, Time, IP Address, Username, URL, Website Description.

The database filters the 300,000 line log by running a number of delete queries. The remaining data is basically websites that are not work related, and should not have been visited. The data is then exported into a spreadsheet, and the database is cleared down ready for the next months logs.

What i am looking to do, is have some sort of way where the username of all remaining users are put into another table/spreadsheet if they are on the final list. Then the next month, if they are on the list again they get marked for a second warning, then third warning etc. However if there is a months gap between, then the counter starts at first warning again.

Im not sure where to even start with this???

 

[PaulO]

Interesting!

Suggest first of all you add an additional Field to each record in your table, being MONTH e.g. 2010_10

Then, once you've cleared down the data, you need to run a crosstab query using MONTH as the Column Header (descending order) and showing USERS with a current month appearance!

From there it should be easy enough to see who qualifies!