Viewing tables side-by-side

[RenaG]

Is there a way in Access 2007 to open more than one table in Datasheet view so that I can look at them side-by-side?

TIA!

 

[Mr. B]

If your tables have one or more common fields, you can put both tables in a query and relate them on the common fields and then only show the fields from each table that you want to compare.

 

[RenaG]

Hi Mr. B,

Thanks for getting back to me so quickly.

I was trying to write a query and wanted to look at the tables involved to help me visualize better what I was needing to do. Does that make sense?

Thanks!

 

[gemma-the-husky]

no it doesnt make sense, to be honest - you ought to know what data is in your tables (I mean the various fields) - and you really shouldn't need to looking at them directly in tables, in the general course of things. You ought to design queries and forms to present the data.

 

[RenaG]

Well, I am a visual person so it helps me when I can actually see the fields.

 

[kcushing]

Is there a way in Access 2007 to open more than one table in Datasheet view so that I can look at them side-by-side?

TIA!

I am trying to do the same thing. Databases I created with an older version of Access do this already. But newer datasheets are tabbed and I can view only one at a time. I am sure there is a setting somewhere to allow me to view the tables one above the other.

I am linked to two different databases with similar tables and need compare data before importing data from one database to another. Viewing more that one table at a time would really help me out.

 

[khalakmu]

In Access upper left corner ..Office Button, click go to Access options , then go to
Current Database, in there Display status Bar mark Option Overlapping windows
and restart access. Table will be in overlapping windows.

 

[RenaG]

Hey khalakmu ~

That was perfect! Thank you for answering my question.

Have a great day.

 

[kcushing]

In Access upper left corner ..Office Button, click go to Access options , then go to
Current Database, in there Display status Bar mark Option Overlapping windows
and restart access. Table will be in overlapping windows.

Yes, thank you. That will be a big help!

 

[khalakmu]

You welcome Glad to show what knew..