Re: query date problem

your asking for everything its got that doesn't have a date equal to greater than the exact second your run the query. Which is probably everything in the table. - Original Message - From: "S R" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 29, 2000 1:25 PM Subject:

RE: query date problem

Wrap CreateODBCDate around it: Where NewDateArc #CreateODBCDate(Now())# However, remember that by using Now(), you're specifying everything older than the date _to the second_ -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 2:26 PM To: [EMAIL

Re: query date problem

syntax problems aside, but then maybe that's what you want to do. - Original Message - From: "S R" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 29, 2000 2:02 PM Subject: RE: query date problem Its a Date/Time field in MS Access. The field has 'Short Format' spe

RE: query date problem

Thanks everyone. I solved it with your help!! From: Brad Tumy [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: query date problem Date: Wed, 29 Mar 2000 15:12:45 -0500 Did you check the data in newDatearc? ...maybe it is les