Search results

Hi Goh! Thank you so much for your help and your patience..I really appreciate it. I fixed the SQL and now I'm getting all the vendors to show up that are in my Actuals table, so that's good. However, when I add a new vendor ID to the Actuals table, I need it to show up over in the...

Ok, thanks again Goh! So my query fields look perfect now: Actuals.VendorID Vendors.VendorID VendorName ...and this is what my SQL looks like: SELECT Actuals.LineItem, Actuals.VendorID, Vendors.VendorID, Vendors.VendorName FROM Vendors INNER JOIN Actuals ON...

Hi Diamond! Thank you sooo much for that "SQL speak"...lol..that is so cool! I've had to make a few changes to my tables so I then attempted to try and make those changes match what you gave me and I'm coming up with blanks..lol I'm trying so hard to figure this out myself but I'm stuck :(...

Hello all! I'm a beginner so please bare with me. I've researched my problem a dozen different ways and can't find the exact help I need so I've come here. I have a list of Vendors on an Actuals Table that will have vendors added to it from time to time. I also have a Vendors Table that...

Hi Steve! Thanks for your help. Yes, when I say "multiple primary keys" it's just because that's how my untrained mind thinks of it...lol...sorry. My boss wants 2-3 fields to make up the primary key and I wasn't sure if this was even possible and I definitely am not sure how to structure the...

Hello Everyone! Is it possible to have 2 or more PKs in a table? Is it even necessary? Is having 'autoNumber' as the PK good enough? Thanks, The Novice (Nani):confused:

Hello All! Ok..so I broke all my tables down and started over, thanks for your help. I have a new table request by my boss and I'm having a hard time finding the answer in my research, so I hope someone here can help :) I have a list of Vendors and their IDs in a "Vendors" table, here are...

Ok Spikepl... So I used your examples but just plugged in the info I needed for what I'm trying to accomplish..thank you so much! However, I can't find an example or template that helps me with my one, burning question.... So here are the tables I have created: Project_Budget...

Ok...thank you sooo much, Spikepl, I'm gonna go give this a shot!

Ok...I read...I studied... I'm seeing now that I need to break down my huge table into smaller tables "normalization". So, since my boss will want to see budget amount by month, I'm thinking I need to make a table that has the following field headers: Project, Project Year, Jan, Feb...

Hi Darkstar! Let me see if I can try and clear things up for you and thanks for responding. I have a "buget" table and an "actuals" table that are set up exactly the same, and they are tied to other financial tables. This is a financials database. My boss wants to be able to compare the...

Thank you for your links, but I'm not sure I have it 100%. I don't know how to use what I just read and relate it to my issues. It seems like I need to make another table, but I'm not sure what kind of table (what fields)? I'm so frustrated. Everything was fine until I had to break this...

Hello everyone! Thank God for this forum... I am not an expert at Access but the executives in my office are looking to me to build this HUGE database, so here I am, doing my best, and I've run into a problem. I have a table with the following field headings: AutoNumber, Budget #, Project...