i have created a query in Access 2003 which pulls info by start and end date
using the between criteria. It works great. Is there a way to have both the
start date and end date field resonses in one dialog box instead of having
them appear in two consecutive boxes?

Thanks in advance and have a great day!

On Wed, 6 Jun 2007 08:46:01 -0700, john mcmichael
<(E-Mail Removed)> wrote:

>i have created a query in Access 2003 which pulls info by start and end date
>using the between criteria. It works great. Is there a way to have both the
>start date and end date field resonses in one dialog box instead of having
>them appear in two consecutive boxes?
>
>Thanks in advance and have a great day!

Use a Form (frmCriteria let's call it) with two - or twenty, if you need them
- textboxes. Use a criterion like

>= [Forms]![frmCriteria]![txtStart] AND < DateAdd("d", 1, [Forms]![frmCriteria]![txtEnd])


John W. Vinson [MVP]

I'm sorry for the follow up but I'm not sure I understand. How does this
make a query run. I dont have a very strong backgound and I dont get how
exactly I'm supposed to use the code supplied.

Thanks again, I really do appreciate your effort in getting me through this.

"John W. Vinson" wrote:

> On Wed, 6 Jun 2007 08:46:01 -0700, john mcmichael
> <(E-Mail Removed)> wrote:
>
> >i have created a query in Access 2003 which pulls info by start and end date
> >using the between criteria. It works great. Is there a way to have both the
> >start date and end date field resonses in one dialog box instead of having
> >them appear in two consecutive boxes?
> >
> >Thanks in advance and have a great day!
>
> Use a Form (frmCriteria let's call it) with two - or twenty, if you need them
> - textboxes. Use a criterion like
>
> >= [Forms]![frmCriteria]![txtStart] AND < DateAdd("d", 1, [Forms]![frmCriteria]![txtEnd])
>
>
> John W. Vinson [MVP]
>