multiple tables

I have a Customers table that holds a customer account number, Customer name, Street, City, State, Zip. I want to make a lookup table for City and a lookup table for State. Should I use the State Abbreviation for the Primary Key or an Autonumber?

I am fairly new to Access but starting to get the grasp of it. I am creating an Access database and I need clarification on using lookup tables. I import an excel file once a week to a temporary table. From there, I append the data to the main tables to seperate the information accordingly. I...

I work in the financial industry and have been tasked to create a database for the department I work in. We will be importing certain financial transactions into this Access database which will store the following information: Customer Name 1, Customer name 2, Adress, City, State, Transaction...

G'day folks, So I am looking for multiple/best solution(s) to summarise/consolidate multiple tables into one. These tables are Bill of Materials (BOM's), on each worksheet will be a table summarising the materials required for each product assembly. The tables are made up of Part Numbers...

I am relatively new at working with queries. I have two tables, one with realized expenses fro certain months and another with budgeted items for certain months. I am trying to create a query which will take all the expenses, put them into the categories I have them labeled under and sum for...

Hi, (First post. Have not yet figures out how to attach example-spreadsheet.) I have a problem trying to incorporate a formula into sumproduct formula. In one table (TableBOSales) I have four columns (År Måned, SAP Avdelingsnummer, Antall, and Flag 1). The flag column matches identifier to...

As the title states, I am trying to import and append multiple sheets from a single excel file into tables in my Access DB. The excel Sheet2 will always be appended to Access table1, Sheet3 will always be appended to Table2 and Sheet4 will always be appended to Table3. The sheets in excel...

Hi Everyone, I'm trying to use MS query via ODBC connection to pull data from one main table while joining two tables (left joins each) to enrich the data. I know that MS query wizard only supports one outer join, but from what I've read, the correct SQL code will work. Think of it like this...

Hello, Is there a way to link a table to another table and have the linked table update as the main one gets updated? What i have is a sheet with a table of a years worth of data, that is updated every day. I will take this data and sort it, say by name and then print it it out as a report...

I am in the process of creating an Employee database, and have multiple levels of data, thus I split it to different tables. Table 1 - General information (Name, Birthdate, phone number and Address) Table 2 - HR information (Start Date, Employee type, Drivers License, SSN, Insurance) Table 3 -...

Hi all, I hope you can help me with this. Probably an Advanced Filter is the solution, but I'm not good at all with VBA. I'm trying to split a table in multiple ones; the new tables should be placed next to each other (1 or 2 blank columns between them) or, as second option, to new sheets. The...

I need some help in writing a query that addresses this problem. I have inherited an access database that has 50 tables within it. All the tables have the same structure and layout. Each table has 25 fields that describe individual loan characteristics. I need to find out all the unique...