Using CREATE VIEW SQL

Hi, I've got two columns, municipality (string) and population (number). And I need to create virtual table which combines these two columns.
I was thinking to do it like this, but it doesn't seem to work. Any idea?

Please Login or Register  to view this content.

Couldn't you use a query?

I guess you're right . But the conspect of virtual tables is new to me, so I'll be happy to understand the syntax. Maybe it doens't work in MS ACCESS?

Access doesn't have views.

What is it you are trying to do anyway?

What's the purpose of this 'temporary' table?

Thank you Norie, that's good to know but what's the meaning that Access doesn't have views?

This "column" (or virtual column) will be used in the where statement, like that:

Please Login or Register  to view this content.

Thank you Kyle it works. And the critical line is this:

municipality & ' ' & population

The syntax is different from MySQL..

Back to my question: specifically do we have equivalent to CREATE VIEW?

Ok PM you somthing. Thanks.