Creating view in Access
-
Hi I would like to know how to create a view in Access??? In SqlServer there is a folder "Views" where u can create views in a very simple way. Searching with google i found that in access are used sql queries instead of views, but didn't understand well. Thanks bye
"For as long as men massacre animals, they will kill each other. Indeed, he who sows the seed of murder and pain cannot reap joy and love." Pythagoras
modified on Thursday, December 23, 2010 8:19 AM
-
Hi I would like to know how to create a view in Access??? In SqlServer there is a folder "Views" where u can create views in a very simple way. Searching with google i found that in access are used sql queries instead of views, but didn't understand well. Thanks bye
"For as long as men massacre animals, they will kill each other. Indeed, he who sows the seed of murder and pain cannot reap joy and love." Pythagoras
modified on Thursday, December 23, 2010 8:19 AM
jadughar wrote:
I would like to know how to create a view in Access???
For that there's word 'Queries' Access .
jadughar wrote:
In SqlServer there is a folder "Views" where u can create views in a very simple way.
View is nothing but the result of query. In SQL you can see the result as Views, But it isn't a physical data. It's just returned result of query.
jadughar wrote:
Searching with google i found that in access are used sql queries instead of views, but didn't understand well.
View in SQL = Queries in Access.
Regards, Hiren.
My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - The ?? Operator. -
jadughar wrote:
I would like to know how to create a view in Access???
For that there's word 'Queries' Access .
jadughar wrote:
In SqlServer there is a folder "Views" where u can create views in a very simple way.
View is nothing but the result of query. In SQL you can see the result as Views, But it isn't a physical data. It's just returned result of query.
jadughar wrote:
Searching with google i found that in access are used sql queries instead of views, but didn't understand well.
View in SQL = Queries in Access.
Regards, Hiren.
My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - The ?? Operator.