Search results

First, thanks for your help. But crap. Feel so stupid. I could have sworn this db was in 2000. But it's Access 97. IIf command won't work in 97 right? I vaguely remember IIf not being supported by one of the versions. And since you got it to work in 2000, then it must be 97. Is there an...

Jon, I did try your changes. But I am getting an error message: "ORA-00920: invalid relational operator".

I d/led Adware and Spysweeper. I will d/l Spybot next. I am also looking into this prog called HijackThis.

Thanks I will definitely try that. Right now I am working on another freaking problem. While doing my research online for that query, one of the sites I went to installed some malicious software on my PC. Now I am battling all these pop ups and whatnot. It's so annoying. I knew I should have...

Hello I am new to this site as well as MS Access and SQL. So any help would be appreciated. Sorry if this is too drawn out. I have this query that returns the previous business day's(Monday through Friday) number of docs sent from my department to another department. I would manually go into the...