jana
asked on
How to create View tables in MS Access 2007 like in MS SQL
We are working in MS Access 2007 and would like to know how to create View tables just like in we do in MS SQL. We're not fluent in Access but we are working with it.
Hi,
Use this:
create view your_view_name
field1,
field2,
........
as
your_select_statement
Please remember:
1. Do NOT use any parameter in your select statement.
2. The select statement should not include any select..into statement.
Hope this answers your query ;-)
Thanks
Use this:
create view your_view_name
field1,
field2,
........
as
your_select_statement
Please remember:
1. Do NOT use any parameter in your select statement.
2. The select statement should not include any select..into statement.
Hope this answers your query ;-)
Thanks
There is no concept of a View in Access. Essentially you would create and save a your query as a 'Select Query' and you can then use it in other queries as if it were a table in your database. In access you create complex layers of queries based on other queries.
ASKER
Still couldn't create the View table. Again, we're kind of new to MS Access.
lsavidge,
your links seems to relate to another version
joy_m,
I get error message "Syntax error CREATE TABLE statement"
abkma,
How do I create and save a my query as a 'Select Query'
lsavidge,
your links seems to relate to another version
joy_m,
I get error message "Syntax error CREATE TABLE statement"
abkma,
How do I create and save a my query as a 'Select Query'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok, got it and worked excellent.
So in conclusion, the query I just created and saved, its like a VIEW table ? Would that be a correct assumption?
So in conclusion, the query I just created and saved, its like a VIEW table ? Would that be a correct assumption?
Essentially yes. You can use any query in another query just like it was a table.
ASKER
Thanx!
No Problem. I'm glad it worked out for you.
Lee