dagreat1mon
New member
- Local time
- Today, 04:28
- Joined
- Apr 21, 2005
- Messages
- 8
Hi all,
I'm trying to make a report which brings up a number of records depending on their renewal date. When the renewal dates were entered into the database they were not entered in standard date format (ie 01/01/2005), but were input as a mixture of full month names and abbreviations e.g.: '1 Mar' or '13 March' or '2 October' or '23 Oct' etc...(note no years were included either because they represent annual occasions.)
At the moment, I have a form set up with two text boxes: Renewal Date From & Renewal Date To. I have then made a query that should select and display all the records between these two dates. Unfortunatly, when the query is run, it does not bring up the expected results. I am not sure how access chooses the results it does bring up, but they are definatly not right. I guess that the problem is that access cannot distinguish between the dates entered in the form and so it is maybe picking up the records alphabetically or in a numerical order.
Does anyone have any ideas about how I can get the report to work properly? I assume that if all the fields were changed to a standard date format (ie 01/02, no years remember) then it would work, although I would consider this the last route to take if possible!
Thanks for any feedback
I'm trying to make a report which brings up a number of records depending on their renewal date. When the renewal dates were entered into the database they were not entered in standard date format (ie 01/01/2005), but were input as a mixture of full month names and abbreviations e.g.: '1 Mar' or '13 March' or '2 October' or '23 Oct' etc...(note no years were included either because they represent annual occasions.)
At the moment, I have a form set up with two text boxes: Renewal Date From & Renewal Date To. I have then made a query that should select and display all the records between these two dates. Unfortunatly, when the query is run, it does not bring up the expected results. I am not sure how access chooses the results it does bring up, but they are definatly not right. I guess that the problem is that access cannot distinguish between the dates entered in the form and so it is maybe picking up the records alphabetically or in a numerical order.
Does anyone have any ideas about how I can get the report to work properly? I assume that if all the fields were changed to a standard date format (ie 01/02, no years remember) then it would work, although I would consider this the last route to take if possible!
Thanks for any feedback
