Views - Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does Access have any functionality similiar to SQL Server Views where we
could get a view of 2 tables????
 
do you mean joining 2 tables in 1 query?
If so the answer is yes. If not, what do you mean??
 
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
 
S Schneid said:
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
Click to expand...

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.
 
Back
Top