Re: Date Range

Try:

....
WHERE ([DateField] >= [Enter Start Date:])
AND ([DateField] < DateAdd("d", 1, [Enter End Date:])

It is liklely that you have non-zero time component in your values and in
this case:

[A Specific Date] + [A Non-zero Time] > [A Specific Date]

--
HTH
Van T. Dinh
MVP (Access)



"Michael Kaendera" <MichaelKaendera@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:81BBB44C-BB37-43A5-AE72-9D006F2BCE15@xxxxxxxxxxxxxxxx
> I have a query that asks users for a date range.It asks the users to put
in
> a starting date and also asks the user to put an ending date. The query
works
> fine but the only problem withthe query is that when I enter the same date
in
> the date range it does not return any records. (Like if I want to get
today's
> records only) I want the query to return records when I enter the same
> starting and ending date.


.

Relevant Pages

  • Re: Report Header
    ... "Van T. Dinh" wrote: ... > is the name of the Parameter in the Query. ... >> the report is based on) is the one the report recognizes. ...
    (microsoft.public.access.reports)
  • Re: Previous Row of Data
    ... Brad ... "Van T. Dinh" wrote: ... > ordering / sorting you want and include this in your Query. ...
    (microsoft.public.access.queries)
  • Re: Export table
    ... primary key on the ID. ... "Van T. Dinh" wrote: ... > sorting / ordering and the use the Query for export and not the Table. ...
    (microsoft.public.access.queries)
  • Re: Select Query By Month.
    ... "Van T. Dinh" wrote: ... > Post the SQL of the [Accounts By Month Query]. ... if I wanted to know which invoices are ...
    (microsoft.public.access.queries)
  • Re: MICROSOFT JET ERROR
    ... So use the roundfunction when writing a formula in your query. ... "Van T. Dinh" wrote: ...
    (microsoft.public.access.queries)