Search results

Pat, Yes, the query works wonderful from within Access. But once I try to run it from ASP I would get the 'Undefined Function' error. I found a work around, but I'd still like to know why I am unable to use the function through Microsoft JET. Here is the original query: ----------SELECT...

Hi Folks: A user named Harry kindly turned me on to the Nz() function in Access. I've been using it liberaly but only recently did I try to use it from an ASP page via Microsoft Jet. I'm using an DSN-Less connection and I'm now getting this error: ---------- Microsoft JET Database Engine...

Still looking for help on this guys. I've got it narrowed down to this: Top Level Threads in which all of the replies are disabled are excluded from the results.

It sounds as if you are tallying the total in a given column for your attendance. By using a "2" to indicate a tardy you are effectivly adding an additional student to the attendance total. The easiest solution for this is to change the datatype to a text field. Then, use some scheme like "T"...

Babe-uk: What is the data type of that field? You can find out by viewing the table in design mode. If it is a Yes/No field then that would be your problem as it only accepts an "off" or "on" value. Change it to an integer field instead and you will be able to add whatever you like there...

Pat, I'm not sure I follow you. Do you mean break it up into two queries or nest a query inside of the join statement? Could you provide an example. I feel like I'm so close to getting this. Thanks.

Thanks Harry, that's awesome. Umm, except: Well everything shows up except for one message. Message #17 has a single response but the response is disabled. Now #17 won't show up in the results. The only thing that would set this record apart from the others is that it is the only one where...

Harry, Add that to my WHERE clause or to my SELECT list? And I assume you mean on my updated query where I specifically add the t2.thread_disabled clause, right? SELECT t1.thread_id, t1.thread_subject, Count(t2.thread_id) AS thread_reply_count FROM bbx_threads AS t1 LEFT JOIN bbx_threads AS t2...

This is driving me nuts. Maybe it can't be done but I would be forever indebted to whomever could crack this problem. OK, it's a doozy so try to stay with me. I've got a message board, similar to this. It is made up of Top Level Thread and Responses. All of the threads are in one database...