Recent content by uselessataccess

Hi there, I have been googling but can't find a solution to my problem. I have a staff training table with a bunch of fields but the two of interest for this query are CourseID and CourseDate. I want to keep a complete training record, with this in mind, when a member of staff completes a...

First of all, thanks a million for the help. I have to level with you though, I don't really follow what you are doing. On the upside, I got it to work. :D Thanks a million. One last thing, if I wanted to query for a particular staff member, how would I add that in?

Hi there, I have already been asking about other aspects of this db on the table forum, I think I am just a complete numb skull at this. I have tried to get this to work but I am struggling. So I have a training database. 5 tables. (PK indicates primary key etc) tblCourses (2 fields...

I have never used unmatched queries before but I reckon i can follow the how to's that google throws up. Thanks. I don't really get what you mean about tracking required courses? At the moment, as discussed above, I have a junction table with 3 fields, IDnumber, TitleID and CourseID. The...

Thanks again, So i have entered the data as described above. Some courses people do are not required. How can I write a query that will return all courses done and indicate the required ones? Also, coming the other way at it, select an employee and returns required courses not done/out of...

Thanks HiTechCoach! I'll do that. Just to check so if I want to link a particular title with a course, I just enter a row in the junction table with the appropriate TitleID and CourseID?

Hi there, I am not too sure how to phrase this question (hence I can't find an answer via google). So I have a training database. 4 tables. (PK indicates primary key) tblCourses (2 fields; CourseID (PK), Name) tblEmployees (3 fields; Name, Staff Number (PK), Title(linked to title in...

Hi there, Would appreciate any help you genii could give me. Okay, I have 8 fields (amongst others) in job description table: 4 employee (text) fields (called emp1, emp2.. ..emp4) and 4 employee hours (number) fields (called emphours1.. ..emphours4) What I need to do is design a query...

Sorry if I was unclear and thanks for your attempt at understanding! :confused::confused: I want something that DOES remember what has gone before it...its not a biggy I can just get the prompt but I thought an autonumber would be more elegant!

Hey there, I want to number reports for auditing purposes. is there any way to this? I know i can do it manually with a prompt box but is there anyway to auto generate it? So, I would want the first report i produce numbered one, 2nd one numbered 2 etc... Thanks A mill, C.

Okay, this is probably really simple to do but as my login name suggests, im not very good with access. no formal training and all! So i have set up two tables. In table A i have 4 identical fields where i can enter employee names (these are looked up from table B). Also in Table A amongst...