How do I copy a table format into a new table?

[LBic]

I am trying to take a table in access from last year's data and copy the
format into a new table to be ready for this year's data. How do I do this.

 

[LeAnne]

Hi,

Bad move. You are storing data as table names (year in this case), which
indicates a non-normalized design. A single table with a year field - or
even better, a date field from which the sales (or whatever) year can be
calculated later using the Year([YourDateField]) function - would be
more in keeping with a relational design, not to mention easier to
query. But if you insist: from the Database window, right-click on the
table being duplicates, select Copy, right-click within the DB window,
select "Paste," then select the "Structure only" option.

LeAnne

 

[John Vinson]

I am trying to take a table in access from last year's data and copy the
format into a new table to be ready for this year's data. How do I do this.

Two answers:

- You can use Copy and Paste to copy a table to a new table. You'll
get the option to copy it design mode only.

- BETTER: DON'T do this! Storing data - a year - in a tablename is
*extremely bad design* and except in unusual circumstances is *not
necessary*. Just store a year number in an integer field, or store a
date field in your table; you can easily create a Query to select only
records from a particular year. This Query can be used as the
recordsource for a form or report, and will be updateable; it will do
everything that your separate tables will do.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps