How to Skip Optional Parameters in Expressions?

[prabhafriend]

How to achieve this in Jet SQL Expression:
Test:=FixDate(#5/31/2010#,,-1)
Like we do in VB and VBA procedures. Possible?

[orange]

Is this what you're asking?
http://support.microsoft.com/kb/210179

[prabhafriend]

That means We can't skip optional parameters in 'SQL Expressions'?

[orange]

That means We can't skip optional parameters in 'SQL Expressions'?
I'm not sure what your original post was asking.
In Access functions there can be optional parameters - that's the link I pointed to.

I have no idea what FixDate(....) represents. It looks like a function.

What are you trying to do?
How do you relate FixDate to a SQL expression?

[prabhafriend]

Orange If I Call the FixDate() in an SQL Expression then it becomes an SQL Statement. Let's Ask this way, How to skip optional parameters in JETSQL Statements? I building the Expression using the Expression box in the Query Builder. Not through VBA.