Database Design | Forum profile

Richard Have you installed the latest Service Pack? That might fix it.

SOLVED: Not sure why I didn't think of using a IN SELECT but that is how it worked. So here is the code now: strSQL = "DELETE " & strLocVar & ".* FROM " & strLocVar & " WHERE " & strLocVar & "." & strLocFld & _ "ID NOT IN (SELECT " & strRemTbl & ".Id FROM " & strRemTbl & ")" DoCmd.RunSQL strSQL

One way here: http://www.mvps.org/access/forms/frm0012.htm another: http://allenbrowne.com/ser-24.html

Mark Take a look at this article: http://msdn.microsoft.com/en-us/library/aa338202.a spx

Many Thanks Estuardo, I will give it a try from the way you sound I believe it will work.

ShadeTree You can use DatePart to get that. DatePart("ww",#1/2/2010#)

Robertomac, If the two tables are linked in a one to many you should have no problem with your query. Your result indicates to me that your getting a crossproduct of the two tables. Art

memo field best practices? Hello, This is a general question, but one that keeps arising: Say I have a table that gets heavily used in queries, forms, etc. (e.g. a "sales order"). Is there any problem with adding a memo field to this table? This would typically be for 'notes' or 'comments', and would be populated a small percentage of the...

Welcome to the site. I think more info about what you're trying to do to give a meaningful answer. It sounds like you could have a table of standardized parameters, which would allow you to compare a specified value against the standard values.

Richard Have you installed the latest Service Pack? That might fix it.