add multiple criteria for interactive query in the same dialog box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
Click to expand...

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])
Click to expand...


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 said:
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!
Click to expand...

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])
Click to expand...


John W. Vinson [MVP]
Click to expand...
 
Back
Top