Hi Everyone,
Here is my issue. I’ve created a report to generate project specific information, to enhance this reprt I’ve added a chart where the user to see the list of tasks associated with the project on the y axis and the date each task begins and ends on the x axis (similar to a gantt). The problem Im having is that access is not reading the dates correctly but is converting them to numbers. Ideally I would like to be able to have the chart scale automatically calculated based on the specific project that was selected, allowing the x axis to only display the time span directly related to that project. Right now when I select for the scale to be auto calculated based on the data the x axis starts at 1/1/1900.
Any suggestions??
Oh also I have my date field set to a Date/Time data type not a number.
Thanks in advance