Recent content by stuffit

I got it. I just had to format the Y axis on my graph. Thanks everyone. sw

accessanswer One problem solved created another. Now that the expression works and puts the proper information in my crosstab query the dates do not show up in my graph. For instance the dates now showing up in the crosstab are like this: Nov/11, Dec/11, Jan/12, Feb/12 and so on. But in...

I got it fixed. I had some bad code in the following library. MyLib C:\Documents and Settings\sweniger\My Documents\productivity\Earnies Lib.mda I deleted it and everything is working fine now. Thanks for all your ideas and help. This site is the best. sw

accessanswer This is what I get when I run the vba in the imediate window. VBA C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL Access C:\Program Files\Microsoft Office\Office12\MSACC.OLB stdole C:\WINDOWS\system32\stdole2.tlb ADODB C:\Program...

Thanks bob I am out of time today but will try it tomorrow. Thanks for the ideas and the quick response. sw

boblarson It's not the project name is "productivity". Thanks sw

Thanks ChiOscar I still get the same error message "undefined function "format" in expression" with both of those expressions. sw

Thanks for the reply so fast. When I try this expression ?Format(Date(), "mm/'dd/yyyy") I get an error message that reads "the expression you entered contains an invalad syntax". sw

I have a query I am trying to run within a chart in a report with Access 2007. The expression I am trying to run is Expr1: format([scdate], "mmm") where I have a date field and am trying to get it to show the month on the chart on the Y axis. The only expression that I can get to work is...