Ichtensen
01-23-2002, 05:25 AM
I have a table with the field "Enddate". I want to get a list of records of the 12 months. In every month i want to see the records where the enddate is bigger than that month. So Access has to look to the month in the date and sort the records by motn 1,2,3 etc. For example january has 30 records that are not ended.
Rich, the last day i could not see any answers.
Pat Hartman
01-23-2002, 06:43 AM
Here's a link to your original post. It is a good idea to select the e-mail reply option when you post a question if you have trouble keeping track of your posts. They move rapidly down the list in some of the categories.
http://www.access-programmers.co.uk/ubb/Forum3/HTML/002835.html
David R
01-23-2002, 12:03 PM
Another option is to use the search screen and check the 'Search For Exact Name (case sensitive)' box near the bottom. Put your own username into the box above that and limit the search by however many days you want to go backwards.
David R