Query opening blank when begin and end dates are entered

[dragongunner0351]

Hello all, I've made a query to view sales orders by a particular date. In the OrderDate field I have this listed under criteria: Between [Begin Date] And [End Date].

For some reason if I don't put in a date I can view a report that shows me all sales orders, but if I put in a date I don't see any sales orders.

Any assitance offered will be greatly appreciated. In the meantime I'm going to continue searching the queries forum and see if I can view any relevant posts.

 

[SkipVought]

How are you entering your begin and end dates? Remember that DATES are not STRINGS and a STRING must be converted to a DATE, which is what the # delimiter does.

Skip,

_[red][/red]

 

[Crowley16]

the criteria is limiting the records returned to only those records where the OrderDate is between [Begin Date] And [End Date]

if you've got no records with OrderDate between those 2 dates, then the query won't return any results. You could try to but in a bigger date range to try to return more results.

if you want to view orders on a particular date, your criteria should be = [date] not between...


--------------------
Procrastinate Now!

 

[dragongunner0351]

To answer the first response the dates are entered as 04/12/07

Crowley16 I will chg my criteria to what you have suggested =[date], also I did try a variety of date ranges.

 

[dragongunner0351]

Here is some more info that may be relevant:
in the orders table the field properties for the OrderDate field is:
FORMAT Short Date
DEFAULT VALUE =(Now0
VALIDATION RULE >=#1/1/1900#
VALIDATION TEXT Date must be greater than 1/1/1900

Also, Crowley16 your =[Date] suggestion had no effect.

 

[lespaul]

First try adding parameters:

PARAMETERS [Begin Date] Datetime, [End Date] DateTime;
SELECT ...


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[PHV]

You may try this:[tt]
Expression cell Order Date: Int(OrderDate)
Criteria cell Between [Begin Date] And [End Date][/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dragongunner0351]

Sorry for the delay in responding I just returned from a staff meeting, thank you for the posts I will try each

 

[dragongunner0351]

Thank you for the posts, Leslie your suggestion worked