Paramiter query "between / and" dates also returns default date.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Art - 04 Nov 2005 05:03 GMT

SELECT tblTable4.var00003
FROM tblTable4
WHERE (((tblTable4.var00003) Between #1/1/2005# And #9/1/2005#));

Also returns the default date. Var00003 is a date field with a default of
[now()].

Reply to this Message

Duane Hookom - 04 Nov 2005 05:20 GMT

What's your issue? I expect your query is displaying a new, blank record at
the end of your records.

Signature

Duane Hookom
MS Access MVP

> SELECT tblTable4.var00003
> FROM tblTable4
> WHERE (((tblTable4.var00003) Between #1/1/2005# And #9/1/2005#));
>
> Also returns the default date. Var00003 is a date field with a default of
> [now()].

Reply to this Message

Art - 04 Nov 2005 06:11 GMT

Yes, it is a new record but it is not "blank". It contians the default date.
Why does it show up in the query that does not include that date in the
parameters?

> What's your issue? I expect your query is displaying a new, blank record at
> the end of your records.
[quoted text clipped - 5 lines]
> > Also returns the default date. Var00003 is a date field with a default of
> > [now()].

Reply to this Message

Randy Harris - 04 Nov 2005 06:27 GMT

If you have a default value for that field, what else would you expect it to
show there? Either remove the default value property or display the query in
a form that does not Allow Additions by default.

Your original statement is not quite correct, where you say "Also returns
the default date". The query is not returning that date. The form is adding
that date as the default for a new record because you have it set to Allow
Additions.

> Yes, it is a new record but it is not "blank". It contians the default date.
> Why does it show up in the query that does not include that date in the
[quoted text clipped - 9 lines]
> > > Also returns the default date. Var00003 is a date field with a default of
> > > [now()].

Reply to this Message

Art - 04 Nov 2005 17:47 GMT

Thanks for the reply. I now have a better understanding of queries.
Art

> If you have a default value for that field, what else would you expect it to
> show there? Either remove the default value property or display the query in
[quoted text clipped - 21 lines]
> of
> > > > [now()].

Reply to this Message