> Why wouldn't you name a column "date" if that's what's in it? because it's a reserved word reserved words produce unpredictable results or "unexpected behavior" <tip type="sql"> reserved words for various databases http://www.macromedia.com/v1/handlers/index.cfm?ID=22056 Access (all versions), Excel (MS Query), SQL Server, FoxPro, Sybase, Oracle, Postgres, DB2, MySQL </tip> rudy