Re: Date range criteria
From: Sahil (Sahil_at_discussions.microsoft.com)
Date: 06/14/04
- Next message: ctdak: "Re: Summary & detail"
- Previous message: Duane Hookom: "Re: Changing Field Value Using Query"
- In reply to: Gary Walter: "Re: Date range criteria"
- Next in thread: Gary Walter: "Re: Date range criteria"
- Reply: Gary Walter: "Re: Date range criteria"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 13 Jun 2004 21:37:01 -0700
Thanks Gary
I tried assigning data types to the criteria expression just as the way you had suggested but this gives me an error saying "The expression may be invalid or is too complicated to be evaluated as it may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables"
Can you please help me out of this?
"Gary Walter" wrote:
>
> "Sahil" wrote
> > Can Some one please help me with this;
> >
> > I want to display records between dates selected by the user;
> > Fort his I have two Calendars cal1 and cal2 in the form FrmReconall to select date
> ranges;
> > In the query criteria I'm using the expression Between [Forms]![FrmReconall]![cal1]
> And [Forms]![FrmReconall]![cal2]
> >
> > But the problem is this works fine and displays all records when the range selected
> is say from 6/1/2004 to 6/9/2004. But when I select the dates from 6/1/2004 to
> 6/10/2004 it displays only the first and last records. I'm really not able to figure
> the problem here.
> >
> Hi Sahill,
>
> Your query is treating your parameters as text.
>
> In query designer, select "Query" in top menu
> and click on "Parameters"
>
> Parameter DataType
> [Forms]![FrmReconall]![cal1] Date/Time
> [Forms]![FrmReconall]![cal2] Date/Time
>
> Please respond back if I have misunderstood
> or was not clear about something.
>
> Good luck,
>
> Gary Walter
>
>
>
- Next message: ctdak: "Re: Summary & detail"
- Previous message: Duane Hookom: "Re: Changing Field Value Using Query"
- In reply to: Gary Walter: "Re: Date range criteria"
- Next in thread: Gary Walter: "Re: Date range criteria"
- Reply: Gary Walter: "Re: Date range criteria"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
