Recent content by Deutz

Thanks MarkK, I used your SQL and it worked as expected. Also, thanks to Galaxiom for your format dates tip which I had not implemented correctly.

Sorry for the confusion. English is my second language after Computerese. I want the ID values that have a specific date (23/11/2015) associated with them but not if they also have another specific date (1/05/2015) associated with them. It does not matter how many times they appear. Thanks Deutz

Hi, and thanks in advance. I am using Access 2010 and have a single table (tblData) with about 100,000 rows with an ID field (ID) and a date/time field (Tmst). Each ID can appear one or more times with one of two dates. In the example provided, the date can be either 23/11/2015 or 1/05/2015...

Also, thanks to JDraw, I tested your suggestion also but since I have a lousy work PC, the query takes a bit too long to run. I'm sure it would be just fine on a better machine. Regards Deutz

Thanks sneuberg, that works very well. Much appreciated Regards Deutz

Thanks for your suggestion sneuberg. I'll give it try. Regards Deutz

I have subsequently tried this SQL but it seems to hang forever ... SELECT DISTINCT tblClient.fldID FROM tblClient WHERE tblClient.fldID NOT IN (SELECT tblClient.fldID FROM tblClient WHERE tblClient.fldCode="Y") AND tblClient.fldCode="X"

Hi and thanks in advance, I have a single table in Access 2010 with about 500,000 client records that I am trying to query. Each client ID can appear in the table multiple times with different letter codes from S to Z. I want to return a list of distinct client IDs where the client has code X...

Putting them in the footer works like a dream. Thanks John!

Didn't think of that as I originally had the subform in Datasheet view and footer does not display in that format. I'll see if that will work with continuous format. Thanks

Did think about that but I have a row of totals textboxes below the subform abbutted up to it so it approximates a spreadsheet like layout so there is no gap between the data and the totals.

Hi and thanks in advance. I'm using Access 2003 and have a subform (continuous) that has a set number of rows and columns, so I don't want it to scroll at all. Textboxes in the subform are locked but users can double click them to update data via another form. The problem is that when you click...

Thanks vbaInet, That was exactly what I was looking for. Rgds Deutz

Hi and thanks in advance, I'm using Access 2003 and have a form with a subform that always displays the same number of rows and columns in datasheet view. Wondering if there is a way to display the subform without having to leave an empty space to the right of it and below it in the subform...

Your Update query now makes perfect sense. Thanks vbaInet for your help and patience.