in a qbe I have a dateadd("d",1,[dateofsession]), in the criteria I have the
dates based on a users input on a form ( frm.frmreports.txtstart = beg date
search, frm.frmreport.txtend = end date search). What is happening is it
bring all the dates for the specific range.

For example, I have 4/16/2006 and 4/21/2006 on my form, so it should only
bring in that date range. What is happening is it brings everything for
April, even 2005 data.

Any ideas?? Thanks for your help, Ryan

On Fri, 19 May 2006 10:58:02 -0700, Ryan W wrote:

> in a qbe I have a dateadd("d",1,[dateofsession]), in the criteria I have the
> dates based on a users input on a form ( frm.frmreports.txtstart = beg date
> search, frm.frmreport.txtend = end date search). What is happening is it
> bring all the dates for the specific range.
>
> For example, I have 4/16/2006 and 4/21/2006 on my form, so it should only
> bring in that date range. What is happening is it brings everything for
> April, even 2005 data.
>
> Any ideas?? Thanks for your help, Ryan

Copy, Paste and re-post the exact Where clause of the query SQL into a
new message in this thread.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail