Search results

  1. S

    UNION Queries

    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]...
  2. S

    Union Query? Help required***

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

    How do i get a query to total the results of two queries

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

    ***Mailmerge Macro***

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

    ***Calling all Report experts***

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

    Application Tracking Database

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

    The Joy of Access

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

    Updating a Query

    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...
Back
Top Bottom