Combining Tables

K

KAitchison

I am fairly new to access and have a question,

so i have 2 tables, they both collect simiar information but we want them
seperate for data input... (if that makes sense).. its actually for
scheduling.. basically the data input is catorgorized to make it easier...

So in this case we have one table for Routine Tasks and one table for
Non-Routine Tasks...

what i want to to is take the information from each and combine it into
giant table which ultimatly can have other things done to it...i'm having a
bit of trouble developing a query that can merge the fields from both tables
together, all of the records will be unique and will therefore need to be in
the table even if task=task etc...

can anyone suggest a way to do this? or is there a better way to go about it?
 
K

KARL DEWEY

I suggest you not use a third table but use only one. Add a field to
indicate Routine/Non-Routine Tasks and use criteria when pulling records. In
your data entry form (separate form for Routine/Non-Routine Tasks) have that
field hidden with default for the type of task.

First BACKUP DATABASE BACKUP DATABASE BACKUP DATABASE
To combine, add the designator field to one of the tables and run an update
query. Then run an append query with added expression field to include the
type.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top