Recent content by ElcoyotldeAztlan

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...