On Wed, 03 Sep 2003 02:24:06 GMT in comp.databases.ms-access, "Tim
Mills-Groninger" <ti***@earthlink.net> wrote:
dateserial(year(date())-1,month(date()),day(date()))
Microsoft is a bit like the former Soviet Union when it comes to consistancy
between applications. Excel's Today function maps to Access's Date(),
Excel's date becomes Access's DateSerial. And don't even get me started on
string functions. sigh.
How about string theory then? Access supports eleven dimentional
arrays <g>
--
A)bort, R)etry, I)nfluence with large hammer.
(replace sithlord with trevor for email)