Prior Values

  • Thread starter Thread starter owilson
  • Start date Start date
O

owilson

Hi,

I have a table that lists amounts by Month/Year as a
string like 200501 for January, 2005.

I have a query based on that table with the criteria:
<Forms!MonthSelect!txtrptdate.

I'm trying to get all amounts posted prior to the
Selected Month. It works except that the month selected,
irrespective of its year of occurance, is not included.

Any ideas? This thing is driving me nuts!!!!

TIA

Owen
 
How about changing that the <= from <

<= Forms!MonthSelect!txtrptdate

But it was working in accordance with what you stated - "... PRIOR TO the
selected month."
 
Back
Top