Compile error. In query expression ‘Format([Sale Date],”mmm”’.

[danaspps]

I have been using this database for several years. I created a query (actually one for each of the last 4 years and one for all 4 years combined), then based a report on each query. Everything has been working just fine. Then all of a sudden I go to open one of the reports and get this error: Compile error. In query expression ‘Format([Sale Date],”mmm”’.
It has been a long time since I made this database and I am very rusty. As far as I know I have changed nothing in the underlying tables. I have attached a screen shot of the table design, query design and an old copy of the report from an old backup. Any help would be greatly appreciated.

[pbaldy]

Is there a possibility of a Null sale date?

[Welshgasman]

I cannot spot anything obvious.

I tried with my data and this worked fine, which appears to be the same as your crosstab?

TRANSFORM Sum(Transactions.[Amount]) AS SumOfAmount
SELECT Transactions.[Description], Sum(Transactions.[Amount]) AS [Total Of Amount]
FROM Transactions
GROUP BY Transactions.[Description]
PIVOT Format([TransactionDate],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");

[danaspps]

What is a Null sale date?

[pbaldy]

What is a Null sale date?

Empty, no date.

[danaspps]

No, every sale has a date. It is like the database just stopped recognizing the date formats. Except in the Property sheet, under column headings, it shows the months. "Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","S ep","Oct","Nov","Dec" so it is recognizing something.

[pbaldy]

Can you attach the db here?

[danaspps]

I certainly thank you for your time and I have no explanation whatsoever, but it is working now.