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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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()].
 
What's your issue? I expect your query is displaying a new, blank record at
the end of your records.
 
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?

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

--
Duane Hookom
MS Access MVP


Art said:
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()].
Click to expand...
Click to expand...
 
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.



Art said:
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?

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

--
Duane Hookom
MS Access MVP


Art said:
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()].
Click to expand...
Click to expand...
Click to expand...
 
Thanks for the reply. I now have a better understanding of queries.
Art

Randy Harris said:
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.



Art said:
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?

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

--
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()].
Click to expand...
Click to expand...
Click to expand...
 
Back
Top