Query OK Report Error

[endri81]

Hi
When I run query :

SELECT datepart("q",[Data e fillimit te tremujorit]) & year([Data e fillimit te tremujorit]) AS PeriodQuarter, clng(IIf(left(PeriodQuarter,1) In (2,3,4),year([Data e fillimit te tremujorit]),year([Data e fillimit te tremujorit])-1)) AS FiscalYear, *
FROM Konsumi_Disaperiudha1_Gimi;
it runs fine and shows table result
but when I try to build a report by using this query I get message:

"The wizard is unable to open your query in Datasheet view, possibly because another user has a source table open in exclusive mode. Your query will be opened in design view"



and if I click Ok and try to preview report I get
Invalid use of Null

How to get rid of this problem?
Regards

[June7]

I tested your query structure with my data and report runs fine. Cannot replicate your issue. Do you want to provide project for analysis?