Try Now() -- "Dick Root" <[EMAIL PROTECTED]> wrote: I had a similar problem a few years ago. As I recall I did the data math in SQL Dick
--- In [email protected], "Dawn Crosier" <[EMAIL PROTECTED]> wrote: > > I don't believe that you can use Today() in Access. I believe that it is > strictly an Excel function. > > Dawn Crosier > Microsoft Word MVP > "Education Lasts a Lifetime" > This message is posted to a newsgroup. Please post replies and questions to > the newsgroup so that others can learn as well. > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of Boehm, Gary D. > Sent: Wednesday, September 12, 2007 7:56 AM > To: '[email protected]' > Subject: RE: [ms_access] Calculating # of days > > I tried that (WHERE (((DBA_cases.lim_date)<Today()+120))) and am getting > this error: > [cid:image001.png@...] > What am I missing? > > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.485 / Virus Database: 269.13.15/1003 - Release Date: 9/12/2007 > 10:56 AM > Yahoo! Groups Links [Non-text portions of this message have been removed]
