I have been trying to get a preceding load to work with a connection to an Access DB. I have so far not been able to get this to work. What I am trying to do is create a reference field that defines the order in which months should appear in a graph. The fiscal year begins in October so in the graph I want October to appear first on the x-axis then November, December, etc..
Below is my current script. It does load the database data but doesn't seem to do anything with the LOAD statement.
ODBC CONNECT32 TO [MS Access Database;DBQ=J:\Fleet\Reports\ScoreCard\New_Scorecard\Scorecard.accdb];
That was the issue. I had read that this error sometimes points to a duplicated field name but I didn't understand how the field name was being duplicated. Thanks for the help!
I am also going to implement your Pick() solution. Much cleaner!
