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

Comparisson operators

100+
P: 171
Hi all
I have a database with an append query. i need to append data to another table for a criteria (date greater than or equal to) through an inputbox as a result of function()
ie the criteria look like nameoffunction()
and the function is in VB
inputbox("date")
i can add data for single dates. but i want the criteria as >= the date input in the inputbox. Pls help

Thank u
Sep 19 '07 #1
Share this Question
Share on Google+
2 Replies


Scott Price
Expert 100+
P: 1,384
Hi all
I have a database with an append query. i need to append data to another table for a criteria (date greater than or equal to) through an inputbox as a result of function()
ie the criteria look like nameoffunction()
and the function is in VB
inputbox("date")
i can add data for single dates. but i want the criteria as >= the date input in the inputbox. Pls help

Thank u
Can't help much without seeing the code of the function and the code of the append query! Post them, wrapped in the appropriate code tags (select the text and click the # button on the reply window toolbar), and we'll have a look.

Regards,
Scott
Sep 19 '07 #2

NeoPa
Expert Mod 15k+
P: 31,494
I may have the question completely wrong as it's written confusingly (I'm sure you did your best with the question in a foreign language), but I think what you want is something like :
Expand|Select|Wrap|Line Numbers
  1. ...
  2. WHERE YourTable.DateField >= NameOfFunction([Please Enter Date])
  3. ...
Obviously you will need to replace the names in here with the real ones that we don't know about.
Sep 21 '07 #3

Post your reply

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