Views - Access 2000

[Guest]

Does Access have any functionality similiar to SQL Server Views where we
could get a view of 2 tables????

 

[JohnFol]

do you mean joining 2 tables in 1 query?
If so the answer is yes. If not, what do you mean??

 

[Guest]

I guess it's a jion?
Example:
1) Have one table of Patient Information, ID, Address information, etc...
2) Have a second table of Accounts, Acct #'s, Type of Accts, Patient ID's,
etc...

We know we can do a query to get the Info. but what we would like is a
'View' or table that would show: By Account Type - all patients of that
account type and the patient info....

Thanks

 

[Brian]

I guess it's a jion?
Example:
1) Have one table of Patient Information, ID, Address information, etc...
2) Have a second table of Accounts, Acct #'s, Type of Accts, Patient ID's,
etc...

We know we can do a query to get the Info. but what we would like is a
'View' or table that would show: By Account Type - all patients of that
account type and the patient info....

Thanks

The Access "equivalent" (well, similar!) to a SQL Server view is a Query
object. If you want patients grouped under Account Type, you can't do that
with a Query, but then you can't do it with a SQL Server view either (you'd
need to create an Access report to do that).

If you know how to do what you want in a SQL Server view, then open the
Query Designer in Access, switch to the SQL view, and type in the same SQL
you would use in SQL Server. Unless you are doing something quite
challenging, it should work with no, or very minor, changes.