Recent content by matthewnorton

Ok, thanks for all the suggestions so far guys, but here is where I sound like a complete beginner... The idea of the Temporary table sounds good to me, I am just a little unsure of how to implement it's use. Say for example my query is: EmpID HourlyWage HoursWorked Salary 1...

Thanks Len, I will certainly give this a try. Thanks again for all your help! Matt. :)

Len, Thanks for the suggestions. There is no option for setting a default value of 0, as we have calculated the actual results experimentally for the "errors" (i.e. it could be 50 or 100). The problem arises when trying to put this known value into the calculated field to replace the "error"...

Thanks for the quick reply Len, The calculated values are only in the query. The problem that I am trying to express is that the calculated field (e.g. Total) doesn't give a useable value for every record. i.e. the calculated field (Total) applies the same formula to every record and returns a...

Hey all, I have come across a problem with my database that I would appreciate some help with. I have added to an existing table by creating a query with calculated fields (calculated from fields in the original table). However, a few values in the calculated fields result in "error" or are...

Fofa, Thankyou so much for your reply. For 2), I kinda thought putting it into rows in Access would be the best option - I was just seeing whether anyone knew a more efficient way. For 1), is that implemented in a validation section in the query - or a filter done previously to the query...

Hey all, I'm not sure whether I should put this in two separate posts, but here goes... I have just started constructing a database which has many levels. Some of the field records may not have an entry (as they may not be known) and calculations must be done between these levels. The bottom...

Thanks a lot Pat (&others!), The change in structure of my tables and the relationships suggested have made it so much easier to construct queries and analyse things. I'm glad you guys are here to help people like me! Thanks again people! :D

Thanks for the suggestion. I have now amended the tables to fit as you have said, I have also created TeamID so that a team name isn't replicated throughout the respective players tables, i.e. Premiership Players. Following from the previous suggestion, would the next comment be to do the same...

I have tried to normalise my tables as you have suggested. I think I have all the right tables, but I am worried about what relationships should be formed and where referential integrity should be enforced. Things that I wish to do with the data are to compare averages (it shows blank cells when...

Hi, I am part of a team working on part of an ongoing project that requires a flexible and easy to update database from which to compile our data. The general format that we have, is that of a "Tree Diagram" (see sample attached). As you can see, this is where one branch has in turn several...