Search results for query: *

The solution turns out to be the use of the double quote around the m for the datediff function call. Using a single quote ' instead of the double quote " fixes the problem

Thanks martiros, that was the problem - the string needed single quote instead of double quote.

Hi all, I've got a Union query that works fine in Access 2000, but when I run the query in an ASP file (MDAC 2.7 using ODBC connection to mdb file) I get the error: --------------------------------------- Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access...

Hi all, I've got a Union query that works fine in Access 2000, but when I run the query in an ASP file (MDAC 2.7 using ODBC connection to mdb file) I get the error: --------------------------------------- Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access...

Here's two solutions: 1) Use an insert trigger in the parent table. After the row is inserted, there is a table call 'inserted' which is a logical copy of the table just inserted into. You can select the value from the ID column for your child table as follows: select /*ID column name */...

I've got a table with two id columns which are foreign keys into the same table: table1 ======== repID asstRepID table2 (names of reps) ====================== id name I want to retrieve a row that has the name of both the rep and asst rep, such as: repID repName asstRepID...