Search results for query: *

Yes they are correct

Well its not working that way since all i get is the "Mth0" etc.. column headings. I cannot go into the report design view and change the headers since the query is showing "Mth0" using your formula

Nevermind i seem to be going in circles with your helpful hints. If you did not know how to do it just say so. The column labels cannot be changed in the report. Thanks for trying

Again this leads me back of having the date being the column header in the report. Since the report is now picking up the headers of "Mth0" how do i change this to reflect the month dates...seems to me there got to be a way to update it but everything i see online states that the format has to...

The date format for the column headings is to show a trailing 12 month volume history for each appraiser (ex. From 5/1/2011 to 5/1/2012, may 2011 to may 2012

Well excuse me for trying to get this resolved and I was asking an expert. By the way, the column headings aren't right on the crosstab query anyways (comes out as Mth0 instead of 05/01/2012, which is what I wanted to see as the column heading on the query). I guess I will move on and try to...

Got that figured out but now my error is Undefined Function "DataDiff" in expression

My original SQL query: PARAMETERS [Forms]![Date Range]![Start Date] DateTime, [Forms]![Date Range]![End Date] DateTime; TRANSFORM Sum([Month Appraisal Order Types Complete].[# of Orders]) AS [SumOf# of Orders] SELECT [Month Appraisal Order Types Complete].[Order Types], [Month Appraisal Order...

Still didnt work -- do I need to add your column header formula into the SQL query? really need to figure this out

Duane Still didn't work -- this is really bugging me that I cannot do a report from a crosstab query. The Month Complete Date is a date field (04/01/2012, 05/01/2012, 06/01/2012, etc...). The error I am getting are the Syntax error (missing operator) in query expression "Mth" &...

Duane not sure what you mean by this -- could you show me the sql query that would handle this? I understand the static number but I need the month as column headings in the report.

Wow I actually asked a question no one knows the answer to? unbelievable

Duane How in the world can I do this if the actual crosstab query is based on month dates -- see my sql for review. I can generate the crosstab query using the month dates but when I try to generate a report from this crosstab query, none of the fields are available. Chris

Duane Actually that was not my question. All I want to do is to get the "mth0" column headings to reflect the actual months and year based on the crosstab query parameters. I have been struggling for 5 days to get the columns headings to show "January 2011", etc...Here is a copy of the...

I am struggling with setting up a crosstab query as a recordsource for a report in Access for the past 5 days. I came across your solution -- see below which has converted the months as "mth0", "mth1", "mth2", etc... the problem I am having is getting the column header to reflect the "mmmm...