Recent content by _Kev

Ok so I think I have even less of a clue now. :) Does this mean I have to tie in the three averages to the building? If so I think I'd have to set up a relationship between the BuildingID field in the Building table and the MonthlyAvg field in each of the the three MonthlyAverage queries. So...

Yeah... I saw that after I posted. I guess I was just a little too anxious to help out. :o

I forgot to turn off the indexes in the junction table. Silly me. Thanks again for the help guys.

I'm a rookie, so I don't have an authorative answer, but I have some questions that may help you (or at least help you get more interest). Is there a way to build a query that splits on the return/enter character (ASCII 10 or 13) using the Chr function? Is there a way to build a query that...

Ok, it was sort of my first guess. Thanks for the clarification. Now that I've established the compound key, how do I establish the one-to-many relationship? After the drag and drop I'm still stuck with a one-to-one relationship.

Howdy all, I'm attempting to set up a junction table. The help for junctions says to make a compound key in the junction table, but I don't understand the intructions for this. Do they mean make all three of ID's the junction table PK's or is there a literal "Make a Compound Key" button...

4) Build a form to display all of this I've been reading up on Junction tables and it seems like this is what I'd need to build the Month/Building table. The problem is that I don't understand the instructions for setting the table up or how I will relate these to items. I think I need to set...

Howdy all, I just started my new analyst job and I've been handed an manually constructed Excel file that I'd like to port to Access. Let me see if I can state my scenario clearly so you can point me in the right direction(s). There are 3 tables listing the following - monthly temperature...