Recent content by oostijen

I wrote the following query: Mid (varname, InStr(1,QueryString, "itemnr=") ,18 ) AS item, This works, however now the results include the word "itemnr=" Is it possible to make a query that returns only the text after "itemnumber="

thanks for all the suggestions. I did the job in SPSS. The used syntax: If date=lag(date) AND visitor = lag(vistor) timeonpage=time-lag(time)

extract text after certain word Hi, i'd like to extract the text after a certain word. (itemnumber) Example: themeplanner=mode&itemnumber=12345678&context=beauty In the abvove example the returned text should be: 12345678. Anybody any ideas?

One last problem The query works fine. There's one problem: when I run the query on a small file, everyrhing works ok. When I run it on the main log (135.000 records, 3.18 MB) access freezes. I tried this on several computers even a pentium IV. Anybody any ideas on how to tackle this problem?

WOW! Thanks a lot guys, this really helped me. One last change: Line 3 Logging.Page to Logging1.Page One last question: I i want to make the assumption that the time spent on the last page is the mean of the time spent on the previous pages. Anyone any ideas on how to do this?

Jon: that's the problem with log files of websites: you never know when a vistor leaves a site, you only know at what time the last page was requested. So for the time spent on the last page you have to make assumptions. Example: mean time of pages visited, mean time of other users spent on...

How to compute difference in time (between rows) Hi, for my study i'm trying to analyse website logs in Access. Below an example First Comumn: Visitor x Second Column: Date page requested Third Column: Time page requested Fouth Column: Page requested a 11/30/01 21:07:25 home.html a...