I have a number of charts in Access 2007 created with MS Graph that I would like to have a horizontal date axis in months.
Currently the axis displays months because I have set the axis majorunit to 365.25/4 and the minorunit to 30.4375 which produces a result that is close but the first date is 1-Aug-07 and the next date is 31-Oct-07. I am not really interested in the one day descrepancy but the axis is confusing to read because the day error changes the month so, for example the 31-Oct-07 would look a lot better if it was 1-Nov-07.
I would like to specify the start date and end date and specify the units as months instead of 30.4375 days so each majorunit starts with the same day of the month. How do I specify the unit as 'months' rather than days?
Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…