Search results for query: *

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...

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...

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...

I have a form based on a query. The query is based on three tables. One table is called Institution, it holds information about universities, hospitals and other institutions. Another is called Contact, which holds information about contacts from the institutions. A third table joins the two and...

I already posted this query in Access Other Topics but it seems more apropriate here. I converted a database from 97 to 2000 and I haven't been able to get a variable from the 97 database to work in 2000. It is: Dim Tb1 as Table. I have tried Dim Tb1 as DAO.Table and Dim Tb1 as ADOX.Table but...

I converted a database from 97 to 2000 and I haven't been able to get a variable from the 97 database to work in 2000. It is: Dim Tb1 as Table. I have tried Dim Tb1 as DAO.Table and Dim Tb1 as ADOX.Table but nothing I have tried works. The module concatenates names and addresses from a table and...

[b]I converted a database from Access 97 to 2000. I need help with rewriting the code for 2000. For example a variable I declared in 97 as Dim Tb1 as Table does not work in 2000? I guess I have to learn more about the ADO/DAO conversion! Any help in this are would be greatly appreciated![b]

I have a check box called FullTime in a form that one checks if an employee is full time. If an employee is not full time then a label and a text box appear with further information. They only are supposed to appear when the check box is not checked. I used this in the form current event...

Is there any way to bring data from an SQL server based application into an Excel spreadsheet?

I have one query and another query that is based on it. Both of these queries have forms that are based on them. The form based on the first query has a button that opens a form based on the second. The second form opens to the current record on the first. I would like to use the find button on...

I have a very complex merged word document with tables and text boxes that is taking forever to print even one page. Is there any way to format/group the items to ease up the printing/spooling time?

I have a form based on a table. I usually use the find tool under the edit menu to find records. It will usually give me a choice of using a particular record or using the whole table that the form is based on. But now it gives me a choice of a particular record or another choice that looks like...

I have a module that concatenates names and addresses. I built it on Access 97. When I try to run it on Access 2000 certain objects such as &quot;Table&quot; are not recognized. Same with &quot;index&quot;. I was wondering if this has to do with a difference between 97 and 2000 because the...