Table Definition

[stewm]

Hello,

I'm converting a coupld of Access reports. I haven't used MS Access very much in the past. I'm trying to create a table in an Oracle data mart based on the values in the Access table.

The Access table appears to contain rows that come from a MS SQL Database. Most of the rows are quite obviously from those tables. However some rows do not have a match on the tables. I can't seem to figure out how they are derived. Is there a way to examine a Access table row to determin it's origins. One row for example appears to be some kind of calculation but I can't seem to be able to find the calculation or the orgin of the data within the table. When I click on table design view it just lists the rows and datatypes and nothing more.

Any idea?

Thanks

Consultants Club Corp.

 

[dhookom]

Reports are/should be based on queries. These queries allow you to mix and match tables as well as create calculated columns. You usually don't create new row/records without the values being stored in one of the tables.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.