var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I need help constructing my query. In my select block I want to include a columns of the form:
However I get the following error message:
isnull(Max(Table1.Column1),'01/01/1901') AS MaxOf_Table1Col1
Wrong number of arguments used with function in query expression isnull...
I have an older query that uses isnull in the form above with no problems and I don't want to have to use the form:
just because I know that the first one should work and is neater. TIA
iif(isnull(Max(Table1.Column1)), '01/01/1901', Max(Table1.Column1)) AS MaxOf_Table1Col1
ISNULL takes one argument, you are feeding it two
why don't you like the IIF?
I'm sure we all don't WANT to use more complex commands, but it's all too often necessary.
... I don't want to have to use ...
What does the first of January 1901 have to do with it? Maybe you could get away with just:
=Max(Table1.Column1) AS MaxOf_Table1Col1
Owner and Manager of
. , Microsoft Access Development Specialists CypherBYTE
Microsoft Access . MCP
And all around nice guy! "Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "
It sounds like you are perhaps confusing the T-SQL ISNULL function with the JET\ VBA\ VB ISNULL function. Look up the two on google to see the difference. If you want to convert a null to a value, use nz().