Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Merging DB's in Access
Name: mmh Date: May 4, 2006 at 15:55:10 Pacific OS: XP CPU/Ram: Pentium Product: Dell
Comment:
I have two databases. Very simple databases, basic data entry, no links to tables or formulas or anything of the sort. Some employees were entering data into db and others into another. Some were entering in both. I need to merge the tables so that all the info is contained in one. I am a novice at Access.
Name: jhunt303 Date: May 5, 2006 at 03:16:50 Pacific
Reply:
In the database window you shyould see Tables, Queries, Forms etc. Click Queries -> "Create new query in Design View", add both of your tables (the key fields should link for you) You should see two boxes (one for each table) with all the fields in. Double click on the fields you want. -IMPORTANT - change the query type to MAKE_TABLE QUERY (under query) then hit the button in the top left to view the results, if they are ok, close the query window and save the query. Run the query and it should prompt you to create a new table, say yes and there you go!
Summary: Im trying to implement a function in Access 2003 to allow the application to find a given field from a give another field in the same record. e.g. I have a table of Assets called tblAssets, im trying ...
Summary: Jennifer, thank you so much! I have the Finnish version of Access 2000 and when I click the "Insert"-tab, there's no indication of that shortcut, just the >* -button that's in the bottom of the form t...
Summary: Message: I'm trying to do a program in Access to my husband clinic, I need first to check if the patient is male or female then if it is male I need to check his age like if he is between 20 to 34 th...
0 
