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

How to specify this in the query criteria?

P: n/a
I would like to specify a date criteria in a query. The criteria is
taken from a form. If the Date text box is blank, I want all the
records. If there is a date, I want all records with the field greater
than the specified date.

If I do
[forms]![frm]![txtDate]

then no record will be returned if the text box is empty

How should I specify the condition?
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
dchow wrote:
I would like to specify a date criteria in a query. The criteria is
taken from a form. If the Date text box is blank, I want all the
records. If there is a date, I want all records with the field greater
than the specified date.

If I do
> [forms]![frm]![txtDate]
then no record will be returned if the text box is empty

How should I specify the condition? [forms]![frm]![txtDate] or [forms]![frm]![txtDate] is null

Nov 12 '05 #2

P: n/a
Thanks

On Wed, 25 Feb 2004 19:25:52 +0000, Trevor Best <nospam@localhost>
wrote:
dchow wrote:
I would like to specify a date criteria in a query. The criteria is
taken from a form. If the Date text box is blank, I want all the
records. If there is a date, I want all records with the field greater
than the specified date.

If I do
> [forms]![frm]![txtDate]
then no record will be returned if the text box is empty

How should I specify the condition?

> [forms]![frm]![txtDate] or [forms]![frm]![txtDate] is null


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.