Re: Help with calcluated columns

[Shay _Fox]

Peter Brawley Wrote:
-------------------------------------------------------
> Oh I see, it's just a query.
>
> MySQL does not speak in Access syntax
> (mercifully). You need to use MySQL syntax, eg
> ...
>
> iif() --> if()
> DateDiff() syntax differs in MySQL vs M$oft
> Surround names containing illegal chars eg spaces
> with backticks (`)
> Do not surround column names with '[]'
>
> You'll need to consult the MySQL manual.

you are right peter.