Search results for query: *

Thanks Sooooooooo Much! That did the trick! Cheers! ClassyLinks 8-)

Hi all! I've got a stored procedure that is not behaving...or perhaps it is behaving, I just haven't trained it correctly. What I'm TRYING to do is have a list of our top 10 selling items. What is happening is that if an item sells more than once, it appears multiple times in the top 10 list...

I think I did it! conn.execute("SELECT count(LLID) FROM tblLLContact WHERE LLARea = 1 AND ContactDate CONTAINS '*July*2002'") Seems to work! Thanks for your help! ClassyLinks 8-)

Hi and thanks for responding. I'm not really looking for the BETWEEN function, if I can avoid it... Because I write this query for every month of the year and would need to do the start/end dates for each month.... I'll give your suggestions of the # a whirl and see what I can come up with...

What error are you receiving? It looks to me like you need to add to your SQL.... sql = "INSERT INTO sites (status) VALUES ('down') WHERE SiteName = '"&rs("name")&"'" ....But I've been wrong before ClassyLinks 8-)

Hey all. This is driving me CRAZY!. I'm attempting to count the number of records in a table that meet my criteria. I can get it to work if I only use one condition....but not more. This works: JulLLContactStay = conn.execute("SELECT count(LLID) FROM tblLLContact WHERE LLARea = 1...

The only thing I can think of is that the from field is usually used for the email addy of the sender. I've only ever had success with a complete addy. have you tried something like: Joe%20%Bloggs? or Joe Bloggs?? ClassyLinks 8-)

I use ASP for this. I've set up a site you can visit that I refer my potential clients to so that they can see the kind of things we can do. This type of thing requires no programming knowledge on the part of the site owner, and they need no software other than a browser. The only catch is...