I am hoping to appeal to your good nature and expertise. I am at the final stages of this project my employer has given to me. I have very little programming experience which you can probably tell due to my posts.
The only thing I have left is to get some reports done. I am using ASP pro 5.1 I have login permissions so users can view their own records. However there are queries which create reports which are not a table and do not have an ownerid which is needed in ASP to have the logged on user view only their records. The reports are for 23 users so I don't want to have to create 23 reports. you gave me some code to get the logged in user strSQL = AddWhere(strSQL, "[CareCoordinators]='" & session("UserID") & "'")
That code works great, but I also need to combine the code you gave me with some code to just show records for the current date. I tried this but it wont work
strSQL = AddWhere([contactdate]='Month(Date())
SO I need 3 different where queries, one for the logged in user, one for the logged in user + the date function to display records for the month and one last one with just the date function.
I asked for help in other forums outside of ASP forums and people were confused and said that there is no way to know what the strsql is doing unless they can see all the code.
Please help
Thank you
