Thanks everyone for the suggestions. I ended up pulling just the user IDs into an Excel spreadsheet and using a formula to compare the IDs month over month and then cumulatively.
Just so you know, CaptainD, the subquery returned no results, and Madawc, I don't think I'm advanced enough yet...
I have an Access 2003 db that contains user hit info. I want to create a report that shows only the new users since last month. I created a report that lists the current month's user info. This is the SQL query in Crystal 10:
CODE
SELECT `allkbusers_OLD`.`USERID`, `allkbusers_OLD`.`HIT_TIME`...
Crystal 10
Access 2003
I have an Access db that contains user hit info. I want to create a report that shows only the new users since last month. I created a report that lists the current month's user info. This is the SQL query in Crystal 10:
SELECT `allkbusers_OLD`.`USERID`...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.