I’ve got a fair bit of experience with Microsoft Access, and when I saw that Base’s query design UI is a dead ringer for Access’s, I thought they would work in a similar manner. For example, I wanted to write an expression of something like:
EXPR: [field1]+[field2]
Which in Access would result in a query with a field named EXPR whose values would be the totals of whatever field1 + field2 for each respective row would be. I would normally type that expression into the ‘field’ name of the query design view. I played with the format in various ways but I got an ‘invalid expression’ error every time.
Apart from ignoring design view completely and writing the SQL from scratch, how can I get the design view to do what I want?
