By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,806 Members | 1,506 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,806 IT Pros & Developers. It's quick & easy.

Select statment, syntax problam.

P: 59
I'm making a reminder, and I want to select all the notes that thier time is passed already.

this is the code I'm trying:

Expand|Select|Wrap|Line Numbers
  1. LSQL = "select ReminderMark,ReminderDate,ReminderTime from Calls WHERE ReminderMark and DateDiff('n',Now,ReminderDate ReminderTime) < 1"
the problam is how to combine DateDiff('n',Now,ReminderDate ReminderTime)

I've tried also using &

I believe its a simple solution, but I just dont know it : \
Jan 27 '08 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 2,653
Did you try [ReminderDate] + [ReminderTime] ?

Jan 27 '08 #2

P: 59
well... no.. :)

its working :)
Jan 27 '08 #3

Expert Mod 15k+
P: 31,489
A simpler solution here may be to say :
Expand|Select|Wrap|Line Numbers
  1. LSQL = "SELECT ReminderMark,
  2.                ReminderDate,
  3.                ReminderTime
  4.         FROM Calls
  5.         WHERE ReminderMark
  6.           AND (ReminderDate+ReminderTime)<=Now()"
I would consider simplifying matters further though, by storing the Reminder time in one as a Date/Time variable.
Feb 2 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.