Recent content by robert693

How can I get the results to print out to new rows instead of within the same text box?

If I have the following code, how can I use it to separate values in a field in my database? declare @xml xml, @delimited nvarchar(max), @delimiter nvarchar(10) set @delimited = N'a,b,c,d,e' set @delimiter = N',' set @xml = N'<root><r>' + replace((SELECT @delimited FOR XML PATH('') )...

If I have the following code, how can I use it to separate values in a field in my database? declare @xml xml, @delimited nvarchar(max), @delimiter nvarchar(10) set @delimited = N'a,b,c,d,e' set @delimiter = N',' set @xml = N'<root><r>' + replace((SELECT @delimited FOR XML PATH('') )...

I have a query with a field that has an output of a string delimited by a semicolon. For example: Jimmy;Joe;Mary;John. I would like to separate each name into separate records: Jimmy Joe Mary John. The string can be of any length. So there can be one name in one record, and there could be 10...

Thank you! It split the string. Your help is very appreciated!

HI, I want to create a formula that will split a field with different values separated by a semicolon, such as "Jimmy;Bobby;Joe;Patty" and have it read out as: Jimmy Bobby Joe Patty The field can have one or many values separated by a semicolon. So, there may be one name, or ten. I tried to...

Hello, I have a report with an ID field (Command.ID) and a date field (Command.CommentDate) as well as several other fields. The ID field can be null. Each ID can have multiple Date fields. I want to pull only records with the latest date field. So for: ID Date 201 01/01/2015 201...

This is the code that I have used to print a matrix to a form. It is really straight forward, I just need to know how to change the appearance of the matrix that then prints. Private Sub Form_Paint() Dim i, j, s As Integer Cls For i = 1 To 8 For j = 1 To 12 s = Matrix1(i, j)...

This is the code that I have used to print a matrix to a form. It is really straight forward, I just need to know how to change the appearance of the matrix that then prints. Robert

I would like to print a matrix to a form but when I do the rows are spaced alright but the columns are spread out about an inch apart from each other. The matrix will not fit on the form well enough to be read. I have tried various things to correct this but none worked. Any help would be...

I have a 20 x 30 matrix in a two dimensional array. I have to do mathmatical operations on it where each element of the matrix is multiplied by the corresponding element in the next row. For example if it were a 3 x 4 matrix 2 3 5 1 7 5 8 2...

I have a project whre I have to use a 20 x 30 matrix of numbers and do mathmatical operations on the elements. The matrix is in a file at a website. I would like some tips on how I could load this matrix into my program, without having to manually enter each element, and also some tips on how to...

I am creating a C project that simulates CPU Scheduler algorithms. The algorithims that are simulated are Round Robin, Shortest job first, Priority, and first come first serve. I have a simulation of 55 jobs that come in. I have randomly created numbers for the burst, quantum time, and priority...

I have a form that is based on a query. The query is based on a two tables, Contact and Survey. There is one more table called Institution. Institution has a primary key, who's value is a number and another field called Name. The primary key of Institution is a foriegn key in Survey table and is...

I have a form based on a query. The query is based on three tables. One is a table that hold info on hospitals and universities. Another is one that holds info on contacts at those institutions. The third joins the two and holds additional info from a survey that the contact sends in. I have a...