Search results

ok got it. I shift-Click on both rows in the design table and set the Key on both at the same time. COOL! Thanks for the helP!

ok- how do I make a compound Key?

ok- could I... Have 3 fields in the Property Table (Agent1, Agent2, and Agent3) that all relate to the Junction Table? 1 Agent will never fill the other 2 spots at the same time- but could fill a different position in another record. I'm just thinking- when I pull a query on the Property...

ok- I setup the Junction Table- do I need a Primary Key for that table, or just the 2 foreign keys?

Right- but understand that each Realtor holds a different position on the transaction- so it's like 3 employees w/ different job functions or descriptions. So I don't know if that's non-normalized or not... Either way- about this Junction table- how do I set it up, exactly? What field do I...

Hey guys- I have a db where I'm not sure what kind of relationship I need to establish between the tables. I have a db that manages real estate properties and realtor information. Each record can have 3 separate Realtors represented (or, as little as 1 realtor). Each Realtor has their own...

Well- here's the problem. Sometimes when I import into a new table- it gives me an error and creates an error table. Basically, it doesn't import all the records. I guess Access tries to assign field types to the data based off of the 1st row in the file. But then in later records- those fields...

Access 2002. Hey guys- I have a software program that I am exporting data out of into excel (it's SQL based). From Excel, I then am importing into Access into an existing table previously created from a similar file (same columns, just different record sets). I am running into problems when...

ok- been thinking about this problem here. What I figure is that I'll have to do 3 separate update queries- 1 query for each Agent all going into the tbAgent table (as well as into the tbAgentOffice table concurrently). Is that right?

Hey guys- I am importing data on a daily basis- some of it contains existing records, some of those existing records have updated information, and then the rest will be new records. I am importing into a table, say, tbImport. I have 3 tables I am splitting this info out to- tbListings, tbAgent...

Any more hints on this one? I'm not sure how to go about checking to see if it's an existing record, or if it will be a new record... Thanks for all the help you can give!

ok- here's what I have- SELECT tbActives.MLS, tbActives.Status, tbActives.Address, tbActives.Area, tbActives.Level, tbActives.YearBuilt, tbActives.SqFt, tbActives.ListPrice, Avg(tbSolds.SoldPrice) AS AvgOfSoldPrice FROM tbListingsRenameColumns AS tbActives, tbListingsRenameColumns AS tbSolds...

How do I post my table Schema's? I probably can't post the data as it's private information...

ok guys- I am struggling here. I've been trying to figure this out, got a small portion of it completed- run the query and I run out of Temp disk space- so it never gives results. Basically- I have all the property data in one table. The goal is to find the how a property listed for sale...

huh. OK- so- if that's the case- do I need to make 2 different statements/passes at this? One to update the existing records, another to append them? How would I go about doing that? Thanks again

ok- so that I am clear... If I do an update, it will update the exsiting records, AS WELL AS load in any new records that don't exist there yet? Thanks bud!

Hey guys- I have a 'Master Table' that holds all my imported records. After a few queries and whatnot- I need to break it down into specialized tables. For example- my Sales Associate info goes into one table (all their contact info, employee code, etc)- while the product info goes into another...

Thank you! I'm having fun learning this stuff while I go! I appreciate all the help - sincerely...

I know this is probably a basic question- but Im not finding a clear answer here. Basically- I have a value that I want to select from a drop down box on a form (not created yet). That value will get inserted into my query for a calculation I am doing. The form will pop up the results of the...

I GOT IT!!!! Here's what I got- This query finds the average price of each property in every area... SELECT tbTempImport.AREA, tbTempImport.ST, Avg(tbTempImport.SP) AS AvgOfSP FROM tbTempImport GROUP BY tbTempImport.AREA, tbTempImport.ST HAVING (((tbTempImport.ST)="CLOSD")) ORDER BY...