Search results

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...

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...

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...

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...