RE: Date Range

Michael:
Do your queries include the equal signs in the less-than and greater-than.
i.e.
([DateFieldInTable] >= [Enter Start Date]) and ([DateFieldInTable] <= [Enter
End Date]) ? If one of the equal signs is not there, you would get the
result you are stating you are getting.
--
Larry J. West, MCSD, MOUS, FLMI, ACS


"Michael Kaendera" wrote:

> 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: ODBC SQL Server Driver Failed (communication link failure)
    ... I have them reinstalling MDAC 2.8 and we'll see ... I guess I should explain better about the query - it's not ... The queries have been ... Michael C. ...
    (microsoft.public.sqlserver.connect)
  • Create a comined Customer and Supplier Telephone List
    ... I can't seem to create the query although I'm quite good at queries. ... GRD ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: List Box Display Anomaly
    ... Michael, since it works fine on one machine but not on the other, you are looking to pin down the difference. ... There were some bugs introduced by SP3 for Office 2003, including combo display problems: ... All of a sudden, the columns from one of the tables is not displaying in the list box, but if I run the query in the query window, all the columns return data. ... I delivered a new front-end to a client this morning and he alerted me the anomaly. ...
    (microsoft.public.access.forms)
  • RE: Finding Unmatched values
    ... Create three queries ... Create a query, using the wizard, for unmatch records, that joins the two ... How can I alter my query to accomplish ... Prev by Date: ...
    (microsoft.public.access.queries)
  • RE: calculated member question -- why (null)?
    ... why would a calculated member with a constant value ... "Michael D." ... ROWS FROM [Adventure Works] ... (My actual query is still slightly ...
    (microsoft.public.sqlserver.olap)