Recent content by eyal8r

Makes sense- thanks!

Ahh- you bring a good point. The last thing I'd want is someone feeling like they wasted their time. I won't do it in the future... I appreciate your help!

hehe- yes, thank you Paul! I post on other sites as I get different responses, if any at all, from each one. Here's my next question... Thank you! Now- if I am going to find the MATCH in the 'master list (Table1), and take a field from Table1 of the matching records and insert it into a...

Hey guys- I have 2 tables- and need to find the record matches between them via their product code. Table 1 has the code as follows (and is considered 'the Master List')- xxx-xx-xxx Where x is an integer. Table 2 has split the 3 sections of the code out to 3 individual fields, like this-...

Basically- it's dropping the records out that do not have any records from tbSold that meet the +/- 10% criteria in the Sq Ft range. So, it's dropping those out of the results. What I'd like it to do is to still display those records, but include 0s in those tbSolds fields. Is there a way to do...

When I run this Query without the WHERE statement/Clause- it returns the accurate 985 records. However, when I include the criteria with the WHERE clause (it takes a range of +/- 10% of the Square Footage size into consideration), I lose 15 records, and only get 970 results. When I increase the...

I thought this was a simple task- but it's proving otherwise. I have a form with a number of combo boxes on it. I want to pass the values selected in the combo boxes to the query, and return the results. Basically, it's a 'search' form. However, it's not returning anything. I used the expression...

Yeah- all the data comes in daily in a flat file. I import that into a temp table, then move it over to the other tables for normalization (well, trying to anyways). As said before- the records contain previous records, changed records, and new records, all in the same file. I won't be doing...

Yeah, this just isn't working right. Any ideas on what I'm doing wrong? I'm about to throw in the towel after 4 days of attempting normalization- and just keep it non-normalized... Heeeeelllllllllpppppp....

Neil- You're right, and wrong I believe. According to this document here- http://support.microsoft.com/default.aspx?scid=kb;en-us;127977 And the posting about it here- http://www.access-programmers.co.uk/forums/showthread.php?t=91911 It states you CAN update and append in one query. But...

ok- Since the Agent Table and the Junction Table are both empty- I figured I need to populate the Agent Table FIRST, before the Junction Table (since, there has to be an Agent in the Agent Table to link to the Junction Table). Right? So- I did this- UPDATE tbImport LEFT JOIN tbAgent ON...

ok- here's what I have... UPDATE tbImport LEFT JOIN tbListings_Agents ON (tbImport.LN2 = tbListings_Agents.MLS) AND (tbImport.LA1 = tbListings_Agents.AgentCode) SET tbListings_Agents.MLS = tbImport.LN2, tbListings_Agents.AgentCode = tbImport.LA1, tbListings_Agents.[Position] = "ListingAgent"...

Well wait- does that insert into the Junction table? What about the Agent table? Does that have a separate update query other than this one? I assume so... but does that mean I am inserting the MLS, Agent Code & Position into the Junction Table, AS WELL AS the AgentCode into the Agent Table...

Yeah, I'll give that a shot and post back! Thanks!

Or, does this REALLY need to be split up like this at all? Couldn't I just keep the Agent's Code in the position field it's in now- and then split out all their contact info into a different table, and still be fairly well normalized? What's the potential problems I could incur if I did it this...