Search results

A five minute job? This is the code I've entered for my Union query select tblApplication.[ApplicantID], tblApplication.[Application Pack Sent], tblApplication.[Candidate Withdrew], tblApplication.[Application Pack Received], tblApplication.[NFUM - rejected], tblApplication.[Invited to...

Ok then... Are you saying that the SQL should be :- select tblApplication.[ApplicantID], tblApplication.[Application Pack Sent], tblApplication.[Candidate Withdrew], tblApplication.[Application Pack Received], tblApplication.[NFUM - rejected], tblApplication.[Invited to Assessment Centre]...

Union Queries Hi everybody, thanks for your help, I've writtena union query, which combnes fields from two tables and merges them into one. The SQL is:- select tblApplication.[ApplicantID], tblApplication.[Application Pack Sent], tblApplication.[Candidate Withdrew]...

Hi, I've quite pleased that I've been able to create a good recruitment database (well with alittle help from my friends on this forum and the occasional help book. However now I have aproblem Basically I have these two tables tblArchiveNFA and tbl Application, from which I need to produce a...

Hi, I have two separte tables in my database, each have the same fields but one table holds current data and the second expired data. How do i get a query to count the total for both tables in an overall total Thanks

Hi, Is there any way to first open a particular query and then merge the results with a document in word? Thanks Scotty

Cheers Thanks Aleb, that's a great help. I hadn't relaised that macro's were relatively straightforward Scott

Sorry Peeps Sorry didn't mean to cause any distress. Think I have been misunderstood. I working at a company in recruitment on a temp contract and personally thought that the system currently in use was inadequate (lengthy excel and paper system) so in my own time thought I 'd try and throw...

Hi, thanks for reading. I'm in the process of producing a recruitment database, used by my work for tracking people's applications and producing reports etc. (see attached) My problem is with producing reports. I was wondering if somebody could produce a summary report which produces some...

Excellent thanks That's great seems to work a treat. Is there any chance though that you could edit it so that the append query runs first and then the delte query, all in the same macro Scotty

Thanks but... Thanks, your macros seem to work great its just that my macro qdelNFA is wrong. i just used some test data and what is happening is that the row in tblAplication is being deleted but not the tblApplicant record. Is there any chance someone could sort out this query so that it...

Hi, please please help, I've got into a bit of a pickle with a database I have to produce for work. It's a database for recruitment purposes basically it needs to track applicants application process. So far I have created the following table:- tblApplicant - Details on each applicant...

Hi, Another problem I am having is how do I set the switchboard to run a query. I tried setting it as a form bu then it would not allow me to merge it with MS word for a mail merge

Hi, I'm in the process of constructing an Access database for recruitment purposes. (Please see attached) the current problem I am having is related to quries. I've got a query whereby a list is produced of all candidates who we have sent an application pack to but have not recieved it back...