Recent content by tlcable7

Thanks, This one worked perfectly... SELECT Count(INPUTDATE) AS C_LastMonth FROM QMortgage_ameriquest WHERE INPUTDATE >= #9/1/2003# Travis Cable

I am new to Access, and having some problems when querying date ranges from a database. Here is my query: SELECT Count(INPUTDATE) AS C_LastMonth FROM QMortgage_ameriquest WHERE INPUTDATE >= '9/1/2003' Here is the error I get: Microsoft JET Database Engine error '80040e07' Data type mismatch in...

What about an online form that creates an SQL Query based upon user selections. Could I pull the data from the database and instead of displaying it in a HTML table, put it in an online Excel Spreadsheet?

Worked... Thanks

It's not working for me... Here is my ASP code: ------------------------------------------ <tr><% for each x in rs.Fields %> <td class=&quot;nowrapWhite&quot; bgcolor=&quot;#666666&quot;><% Response.Write(x.fieldname) %></td> <% next %></tr> <% do until rs.EOF %> <tr><% for...

Does anybody know how to export recordsets as tab delimited text or Ecxel files? I need to bundle the data up to send to some clients. I have heard that there is a way to set the Doctype of a page to an excel format, and then make the excel version available online...? Please Help. Travis Cable

I am filling an HTML Table with values from a select statement. I would like the first row to have the Column Names from the database. How do I select the column names? Please Help. Travis Cable