Search results

Thanks for your help i'm gonna try this, I was busy the past couple of days so I didnt have a chance to try iy

The Excel Spreadsheet has multiple columns, certain columns make up different tables all that data is coming from one sheet (sheet1) and that not the problem because it's coming from one sheet, however one of my tables is getting its data from sheet2 (same spreadsheet just on a different sheet...

Hello Everyone I have question about filling in ID numbers to connect two tables to together using a Many to One Relation ship. I have been working on a database with data I was assigned to import into certain tables from here I'm supposed to make it all connect. I often use the query design...

Thanks guys for the answers Minty it wouldn't be used just for display purposes they also want to add the colors with new entries on a form.

Hello all, I had a interesting request on a form and was wondering what you guys think. Basically I will use this example If I have many cars with many colors yet many cars can have many colors how can I show one car that has many colors If I'm just using one Field of colors, Normally I...

Wow I would 1st thank you for making the excel sheet, I think we are in the right area the only thing is and this my fault for not explaining, the other sections would be like Manufactureidtable, Countryidtable, YearidModels, Carfield, those would be the 4 sections all different data and...

Here is a better example four sections of Data that all are related to 3000 entries, (please see uploaded image) Of course someone could go one by one to match the data however, lets reduce the time by using a query what I have done is used the excel data to match the Name of the data with the...

Thanks I think this puts me in the right direction however it looks like the SQL is only connecting the 4 tables to the "ID Connect" table, from there I would like to connect it to the main data table with the 3000 entries that, Keep in mind the ID Connect table already has all the IDs that...

I think I'm explaining it to hard, it's more simple to show, I drew a basic idea on paint

Ok Guys I think I got a real hard query to create lets see if we can solve this So I have been requested to created this database base off of one excel sheet, i'm in the process of adding this data to make sure the data fits in with the database ER diagram. I have had to restructured/add...

Thank You guys I got it to work

I have the data in both excel and access which way do you think is the easiest way to delete the duplicate row

Thanks! looks like i will try DELETE (SELECT COUNT(*) FROM TABLE1 AS T2 WHERE (T2.Field1 & T2.Field2= TABLE1.Field1 & TABLE1.Field2) AND T2.AutoNumberField <= TABLE1.AutoNumberField) AS Expr1, * FROM Table1 WHERE ((((SELECT COUNT(*) FROM TABLE1 AS T2 WHERE (T2.Field1 & T2.Field2=...

I dont have a link to post my photo (or maybe I dont know because I'm new) Here is a sample set that's really no different at all from my database expect I have over 3000 Rows that are duplicated and scattered ID State City County (field names sorry I can't...

Hello all I'm working a project and i'm wondering if there is an way to delete duplicate rows fast. I imported a section of my excel sheet that has duplicate rows, at 1st I tried to copy the table and "just structure" and turn one of my fields to No duplicates in the Indeed because this field...

well I bring up table IDs because I have tables that are related to each other so for example If my main table is cars and my related tables are colors, year,manufactures I would like to automatically fill those columns in with their IDs so for example CarID Car ColorID YearID...

Hello I was wondering if anyone has found a way to set a DataType just as a Year but also include AD and BC. I know there is Date/Time and those formats are not what I'm looking for. Any thoughts or ways around this? is this a limitation? Sure i can have a Text field and type all my years...

Basically I'm looking for way to automatic fill everything (data) in Access from an Excel sheet into specific tables and have all related IDs connected. (I dont think that is possible when in less you create a large VBA code with IF statements) I already have a code where I can import an Excel...

Thanks If thats the case I know one other way which would be to create a VBA code but if I have a large database of 3000 unique names and they all have shared related fields then I would have to create a VBA code stating if statements that have go though every cell in each columns and state...

is it still possible for me to add more code to this one query performing the same task but on other tables?