B
Bonnie
Hi there. Using A02 on XP. Not a programmer but have used
it long enough that this should not be a surprise to me
but holy, moly! Have a number of reports and forms using
queries as control source. Many have parameters such
as 'From what date to what date?', 'Start Date' and 'End
Date', etc. Most reports are quarter or annual periods. A
Supe decided to analyze more detail and ordered a YTD
report (I use criteria forms to fill in my parameter data)
and keyed into parameter inquiry the weekly period dates.
Jan-Mar record count is 72. Using parameter:
Between [Forms]![fCriteriaFromTo]![BeginDate] And [Forms]!
[fCriteriaFromTo]![EndDate]
If I ran each separate month, my totals were not matching
up. I discovered that in Feb, there were 4 contracts set
up on the 28th. They show on the Jan-Mar but not on the
Feb only data. The dates keyed in were 02/01/2005 and
02/28/2005. UGH! Is Between not the right expression to
use? What should I use?
Can someone point me in a direction to read up on this and
how to work with it? Thanks in advance for any and all
help and advice!
it long enough that this should not be a surprise to me
but holy, moly! Have a number of reports and forms using
queries as control source. Many have parameters such
as 'From what date to what date?', 'Start Date' and 'End
Date', etc. Most reports are quarter or annual periods. A
Supe decided to analyze more detail and ordered a YTD
report (I use criteria forms to fill in my parameter data)
and keyed into parameter inquiry the weekly period dates.
Jan-Mar record count is 72. Using parameter:
Between [Forms]![fCriteriaFromTo]![BeginDate] And [Forms]!
[fCriteriaFromTo]![EndDate]
If I ran each separate month, my totals were not matching
up. I discovered that in Feb, there were 4 contracts set
up on the 28th. They show on the Jan-Mar but not on the
Feb only data. The dates keyed in were 02/01/2005 and
02/28/2005. UGH! Is Between not the right expression to
use? What should I use?
Can someone point me in a direction to read up on this and
how to work with it? Thanks in advance for any and all
help and advice!