Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Update Count Problems
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 =...- nsl100
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Split Comma Delimited Cells Across Rows
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...- nsl100
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
Resource - "Max. Unit & Task Duration" Relationship
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...- nsl100
- Thread
- Replies: 3
- Forum: Microsoft: Project
