Search results for query: *

Fixed - having poked around these forums and elsewhere I have solved my problem - see below: UPDATE table Z SET columnA = DCount("*", "tableX", "colB = 1 and colC = 2"); In addition I included some data in tableZ to ensure that it could be updated.

Apolgies. By empty I meant that the database contained a couple of rows with null (zeros) values. I have just added some values into the rows and attempted the query. Access still doesn't like the query being run and hands me a 'Operation must use an updateable query' message.

Hello All, I have recently discovered that I cannot UPDATE a table with the results of a conventional COUNT query. I have struggled all day to find a work around for this problem but to no avail. Outlined below is what I'm attempting to do in 'conventional' SQL. UPDATE tableZ SET columnA =...

Hi All, I have an access database consisting of one table which is an pointing to an excel spreadsheet. In the table I have a number of cells (in a column called 'Name') that contain text delimited by commas e.g. "John Smith, Jo Bloggs, Peter Pan". I wish to split the text on the commas and...

Thanks chaps, problem solved. The addition of the 'Work' column was key. Thanks Again Neal

Hello All, Is there a way where I can get Project to push out the duration of a task, dependent on the 'Max. Unit' value for a given resource, when the resource is created on the Resource Sheet. For example: On the Resource Sheet (View->Resource Sheet) I create a resource called 'Neal', who...