Recent content by Paulstandere

Craig, Thanks a lot for having a go at solving my problem, it sounds very interesting. I might not get a chance to look at it this morning (UK time) but hopefully this afternoon. Thanks again, I appreciate it. Paul

Clarification Len, I think we are talking at cross purposes (probably caused by my naming convention) You are right...a table specifically required to store all data about staff would contain Name, Rank, Serial Number, Sex, Date of Birth as well as, in my database Staff ID. Let's call this...

Len, Thanks for the reply I will go a read up about 'normalization' to see if that clears up things for me. The data structure in Tbl Staff Data is correct. The table is supposed to have a record for each day's performance for each member of staff. (This is the file structure that is...

Linking By Staff ID By linking Staff ID in Tbl Staff Data and in Tbl Team Lookup within a single query I will get 20 records instead of the 15 records I require. This would be caused by having 2 records for Jayne Cole in Tbl Team Lookup The five records I want to return would be: 600-002...

BACKGROUND I am desperate to solve this problem but unfortunately I have not been able to figure it out. Below I will outline a design of a database and the desired results. I know what I want to do but I don’t know how to do it (or whether it is impossible!) DATABASE DESIGN The design...

FoFa...more detail please if possible Fofa, Sounds like you know what I mean and how to solve. could you give me detial about how you actually achieve this. What do you do in the query to make it return the right value?

Here Is The Database Keith, As I suggested this is a little more complicated than I described in my original post. However it isn't over complicated and the same logic is there. Line - is called SplitSkill and will be a three digit number Description - can be called Splitskill or Description...

Keith, Thanks for the offer of help. I will create a simplier version of my db (due to size issues) and post it shortly. The field names will be different because I tried to make the example in my original post easier to understand. (Unfortunately this is the first time I have gone to any...

BACKGROUND The current challenge I have in MS Access in really giving me a headache. I can’t seem to find an answer or indeed think “outside the box” so I am hoping there is someone who can help. Below I will outline the design of my database, the problem I have and my proposed solution. My...