trouble with tables

[apotheosi]

Hi.

I have two tables.

One (called "with description") with a large number of entries with
the following fields:
IOM# Monitored Location Project Severity Entry Type Record Type Team
Date Short Description

and the other <called "07-08") has a subset of the first table without
the "Short Description" field. ie.:

IOM# Project Entry Type Severity Problem Date Record Type Team Fiscal
Year Entry Severity

What I trying to do is...

Create an table and eventually an excel spreadsheet that has all the
entries from the "07-08" table with the "Short Description" added to
the corresponding entries.

(all the IOM#'s from "07-08" exist in "with description")

Please let me know if anymore info is necessary, as this is my first
encounter with MS ACCESS .

Thank you,

Joe

 

[John W. Vinson]

Hi.

I have two tables.

One (called "with description") with a large number of entries with
the following fields:
IOM# Monitored Location Project Severity Entry Type Record Type Team
Date Short Description

and the other <called "07-08") has a subset of the first table without
the "Short Description" field. ie.:

IOM# Project Entry Type Severity Problem Date Record Type Team Fiscal
Year Entry Severity

What I trying to do is...

Create an table and eventually an excel spreadsheet that has all the
entries from the "07-08" table with the "Short Description" added to
the corresponding entries.

(all the IOM#'s from "07-08" exist in "with description")

Please let me know if anymore info is necessary, as this is my first
encounter with MS ACCESS .

Thank you,

Joe

A very simple query will work if IOM# is unique within both tables (it will be
if it's the Primary Key).

Create a Query joining the two tables on IOM#. Select all of the fields from
the (badly named) [07-08] table and the [Short Description] field from the
[With description] table.

If [IOM#] is not unique then you've got problems: how can you tell which
description applies to which record?

You can export from the query to Excel without needing to make a new table.

A few notes: using # in fieldnames is a bad idea, since it's a date delimiter;
Date is a reserved word as is Year, and neither should be used as fieldnames;
and your example has fields named [Date] in one table and [Year] in the other.