Access will create this kind of query for you - create a new query and choose the "Find unmatched query wizard" from the menu, then follow the prompts

SELECT dbo_pod_surgery.name, dbo_pod_surgery.PHC_ID, dbo_pod_surgery.[Contact Date], dbo_pod_surgery.[Referral Date], dbo_pod_surgery.activity__2

FROM dbo_pod_surgery

WHERE (((dbo_pod_surgery.PHC_ID)="22/15729" Or (dbo_pod_surgery.PHC_ID)="23/13278")

AND dbo_pod_surgery.PHC_ID NOT IN (Select dbo_pod_surgery.PHC_ID FROM dbo_pod_surgery

WHERE dbo_pod_surgery.activity__2 = "AS0630")

);

Jeff Moden (12/1/2008)

My most sincere apologies... I was just cranking through some posts and didn't notice this was for MS Access... since...

You can do it thus in Access:

SELECT Sum(IIf([Dept]="Sales",[Salary],0)) AS Sales, Sum(IIf([Dept]="Accounting",[Salary],0)) AS Accounting

FROM emp;

Try

LEFT([sAMAccountName], 100)

This will take the leftmost 100 characters

Many times you can, but sometimes you have to do it row by row

I don't know about Acc2007, but previous versions have a Long Integer data type that handle numbers from –2,147,483,648 to 2,147,483,647

If this isn't big enough, you can use Single...

If you can change the code that updates each record into an UPDATE statement that runs against the table, you will get a massive improvement in speed

e.g. This loops...

You can write code to run each of the queries in turn - you can even write a macro to do this, but I don't like macros so wouldn't recommend...

The problems of raised expectations by jurors who have watched CSI and similar shows are recognised as in the legal world - the CSI Effect

The shows also give criminals hints...

From Microsoft's Access specification(http://support.microsoft.com/kb/302524/en-us)

Number of characters in a Memo field:

65,535 when entering data through the user interface; 1 gigabyte of character storage...

You can use the User Roster to return the name of the computer that the offending user is connecting from - see here:

http://support.microsoft.com/?id=285822

http://www.fmsinc.com/free/newtips/access/accesstip2.asp

Multiple users of one adp is not a good idea anyway - performance will be greatly reduced and you will have lots of concurrency problems like the ones you are...

We use an Access 2003 front end (adp/ade) to a SQL2000 back end with over 40 users and have no problems - each has their own copy of the front...

Try this:

exec master.dbo.xp_cmdshell 'DTUTIL /SQL "DAPA AVS File Creation" /COPY FILE;"e:\server\data\mssql\dba_scripts\disrec\dts\DAPA AVS File Creation.dtsx" /Q'

Without the quotes I get an error of Option AVS is not valid

With the quotes...