get previous values

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

owilson

Hi,

I have a table that lists billing amounts by month, year.
The "date" is diplayed as a string - 200501 for Jan, 2005.

I am trying to create a query that displays all
information prior to a selected month. For instance,
If I select January, 2005, I want the query to display
all information from Dec, 2004, Nov 2004 etc.

I have < Forms!frmMonthSelect!txtrptdate as a criteria in
the query. I get all information I want except none of
January's info shows up, not even January 2004, 2003, etc.

All the data related to the selected month is ommitted,
irrespective of the year it occurred.

Any help on this would be greatly appreciated.

TIA (the wall you save may be mine :))

Owen Wilson
 
You haven't told us what you're typing into the txtrptdate textbox, so it's
pretty hard to debug what might be happening. Tell us what you're doing and
also post the SQL statement of the query that you're trying to use.
 
Back
Top