Query not calculating correctly

[cpb]

@avvy651

how do you get the text formatted

did you follow this link (direct mode) first given in my post on 30 Dec 2022 18:35.
.
when composing and saving SQL queries in Base I will always use direct mode whenever possible.
.
if you do not use direct mode then Base will alter the SQL, queries will be saved as one long unformatted string, unquoted field names and aliases are double quoted and comments are appended rendering them useless.

@avvy651

there is no design view mode and it is greyed out

the GUI can only handle simple SQL statements.

[avvy651]

@cpb
err no I didn’t follow then said link. I must have missed it!
I have now and I see it is quite easy to do just by selecting ‘Run sql command directly’
I’ve changed a couple of other queries to direct mode now, but I found that they made the associated form uneditable, so I had to change them back for now.
I’ll look into that.
Thanks again for your time and work, much appreciated.