Search results

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.

Yes, I want a datasheet layout for viewing but I thought you meant multiple textboxes for editing when you said "Here's one more suggestion, why not display the records and allow editing in separate boxes above the subform." I suppose you actually meant one box to enter the Range, one to enter...

I'm almost there but still a little unsure of how to get the value from the textboxes to Table 1. Your Update query is somewhat unclear to me. For instance, lets say I have the following textboxes: txtCostA1 - holds the Cost where Type = A and Range = 1 txtCostA2 - holds the Cost where...

Sorry, don't know what you mean by 'four folds'. I did start out with the idea to use separate text boxes on another form or above the subform for saving. The only problem I have with that solution is how do I know where to save each textbox value in the temp table, or if not using the temp...

Shouldn't be a problem using Table 2 as a temp table in a multiuser envirionment as this db is split with the temp table local to the front end (each user will have a copy). I think Table 1 is normalised correctly, unlike Table 2 which is de-normalised for subform display purposes. So if this...

I do want to display the values in the subform so I need a way to load the values from Table 1 into the subform/temp table and a way to save the values in the subform/temp table back into Table 1 in the right places. Rgds Deutz