By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,124 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 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


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

Regards,
Fish
Jan 27 '08 #2

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

its working :)
thanks!
Jan 27 '08 #3

NeoPa
Expert Mod 15k+
P: 31,186
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.