Search results for query: *

Yes indeed PH, Operation must use an updatable query was what happened. Your solution worked a treat! many thanks y'all

i've tried this: UPDATE tblApplicant T INNER JOIN (Select FirstName, Surname, JobTitle, MAX(email) As [GoodEmail] FROM tblApplicant Group By Surname HAVING MAX(email) IS NOT NULL) Q ON ((T.FirstName = Q.FirstName) AND (T.Surname=Q.Surname) AND (T.JobTitle=...

i'm lost!! where does Q come in? Q ON T.ApplicantName = Q.ApplicantName sorry guys i am a little thick.....

Thanks Golom but its from the same table that I need to run the update eg. Applicant ID Applicant_Name Applicant_Email 1 John john@x.com 2 Mark Mark@x.com 3 John 4 Mark 5 Fred...

I have a table of applicants which has a unique applicant number as the primary key, however the same applicants have been entered again and again. I am trying to clean this up step by step. Currently I am trying to update the email field if it has been entered in one of the applicant records...

Hi, I am trying to check if a folder exists and then if it does I will open it using: FollowHyperlink "\path\to\folder" Otherwise I would like to create a new folder. has anyone got any ideas how i should go about this? many thanks austin

I'm trying to open Windows Explorer at a folder that relates to the current record. n Error GoTo StartError Dim objOutlook As Object 'Create a Microsoft Outlook object. Set objExplorer= CreateObject("WinExplorer.Application") Set objExplorer = Nothing Exit Sub...

I'm using a bespoke Access application which is in Access 2002. I can't seem to merge from a query to Word. Do I need to set up a Data Source for this to happen? I've been trying to do this but am having no joy. Can anyone run me through the steps for setting up a new datasource if my user...

I am trying to do a mail mergre which I need to join two queries, one pulling all salary payments for a department and the other pulling stationary expenses, which i need in the one row. I wantto join them on the department reference number, so the result would be Department Salary Yr1...

SORRY when i try to run the suggested solution it brings up the same values for Salaries as it does for Consumables..

SELECT DISTINCT GrantRef, "ItemType - Salary", Yr1... , "ItemType - Course", Yr1... FROM tblName as t1 JOIN tblName as t2 ON t1.GrantRef = t2.GrantRef "ItemType - Salary" What is this meant to do, its acting as an expression and appearing exactly as it is in the SQL

Crowley, Thanks for that but I need spoonfeeding here, i'm just a newbie!!

I'm trying to do a mail merge but am having trouble getting the info I need.Basically I am trying to run a query that will put the figures for the same grant ref into one line, ie that all items belonging to that grant will placed together. GrantREf ItemType Yr1 Yr2 Yr3 Total GG021 Salary...

I need to add a field to a table but an alert box comes up telling me that i cant make a change to a linked table. How can I achieve this? To be honest I dont have a clue what a 'linked table'is! Any help on this is greatly appreciated!