Search results

Hi, this is driving me nuts :( I've done it before for something similar, but i can't remember where I have a export in CSV that I've imported to a temp table. The Date is stored as 20101001 YYYYMMDD Before I'm sure I used an example using MID, but I can't find it. I've seen the use of Cdate...

Scenario first. Our employee's are scored on responses that they give to inbound customer emails. There are 10 questions and the score is calculated on the average of all 10 questions. Attached is my proposed table design. With help from another member here (Thanks) I know now the basics and...

Hi all, I've searched the forums for surveys and questionnaires, picked up a few pointers and watched a online tutorial here but found it was based on a non normalised table. I've created the survey as a non normalised design, works fine, just getting reporting hicups with null fields etc, so...

I have a small Database split FE \ BE each user has a local copy of the FE on their desktop. The FE settings are set to No locks and Shared. The parent form is tied to a table. There is a sub form (tied to a table) on the parent form. The is a onCurrent event that checks to see if the main...

My normal access helper is away at the mo, so he's told me to ask here! I have a training database that stores our employee's training records. The main courses table has various fields that store data, two significant ones are CourseID and EmployeeID. Now the little issue I have is when...