Search results for query: *

Let's say I have a table called d_gift. The table includes the following fields: d_giftkey, d_giftdate, d_gifttype and d_giftamount. A person can make multiple gift transactions which means the data would show vertically based on the number of transactions. Is there a way syntax wise to set...

I have a created field in Access called Birthdate(text)which is blank. I want to pulled 3 fields, birthm(text) birthd(text) and birthyr(text) into the created field called Birthdate. The display should read MMDDYYYY (ie 09112007). In the query section in Access, must I do an update query and...

Using Crystal9 to create a report that requires a specific grouping. I want to display some data as follows: On detail Line A dbo.Prospect_name On Detail Line B dbo.Leader_name On detail Line C dbo.Campaign_Value Here is an example: John Smith (dbo.Prospect_name) Ed Smith...

Here is the SAS program I wrote to display a userid and the count of the userid: proc sql; create table address1 as select addruserid, count(addruserid) as addrCount from my.address where addrdate between '26-feb-2007'd and '31-mar-2007'd group by addruserid; run; Everything works okay except...

I am using crystal 8.5 (have access to cr 9 and 10). Here is a description of a report I am trying to do: Name Name Type John Smith preferred John L Smith formal Address Address Type 1313 S Street Miami Fl Preferred 125 T Street Washington Former...

Using MS SQL Server 2005, I want to display instances of data horizontally. For example if I choose select membid, membtype from membership where membid = '0001' I would get 0001 c2 (0001=membid, c2=membtype) 0001 c3 (0001=membid, c3=membtype) Is there a way to set up an sql statement to...

I have an sql table called GENERIC. It has a SORTNAME field. Here is an example of data SMITH/JOHN. It also has a NAME field. Here is an example Mr. John SMith. In my cross tab I have a formula, GENERIC+''+Name. This is the only way I know how to alphabetize the name. As we know the...

In a sas.log file I have the following: smith (data type is text or $) 2006-03-02:00:00:00 (data type is date time) my report (data type is text or $) The log file lists everything vertical or 1 line for each entry Issue#1 : I need to parse the data into sas and create a table that looks like...

In a sas.log file I have the following: smith (data type is text or $) 2006-03-02:00:00:00 (data type is date time) my report (data type is text or $) The log file lists everything vertical or 1 line for each entry Issue#1 : I need to parse the data into sas and create a table that looks like...

Is there any way to display multiple lines of data (which display vertically by default) in a horizontal or side by side way on a crystal side. I tried doing this on the front end or in the sql table that crystal pulls data into but that does not work. For example if a person has 1 degree a...

Here is my situation. I have a script select schoollookup, degree, schoolname from school left outer join degrees degr where degr.table_code=degree Output: If a person has 2 degrees, the first degree will be schoollookup 1 and the second will be schoollookup2. They will display veritically...

I have a report that creates a work table as follows proc sql; create table address as select addrdate,addruserid from d.address where addrdate >= '05-feb-2007'd order by addruserid; quit; 1. Is there a way to have SAS run this report automatically at 4:00PM each day everyday and put it in the...

I have the following update query in SQL update dbo.core set birthyr = Year(BirthD), brthmn = Month(BirthD), brthdy = Day(BirthD) Now my boss wants me to turn off triggers while this update query is excecuting then turn it back on. I have not used triggers prevously but I...

Here is my situation: I use an sql table called userlist. I bring the table into MS Access and create a make_table everyday and it is done manually. Does anyone know a way to automatically invoke either sql enterprise manager or ms access thorugh a macro to automatically produce a simple...

I ran a query to show an id and birthday as follows: select id,birthd,brthyr,brthmn,brthdy from dbo.core where id= '0000000' The results are id=00000000, birthd=1877-01-01, birthyr=null, brthmn=null and brthdy=null I want to take the birthd and populate it into the three null tables. Thus I...

I have a report that must use the same group throughout the report. I am repeating the group by selecting insert section below. Each group insert includes a different set of subreports. Here is my question. Is there a way to uniquely name each group section so that I use the Keep group...

I am using one group due to use of several subreports. I repeat the group (we will call it coreID group) Here is a sketch: Group1a:coreid Name Group1b:coreid Address Group1c:coreid Employment In this example the employment may actually continue on the next page. Since I am using only 1...

I attempted to add a system DSN ODBC connection. This connection requires an SQL login and password. I successfully added ODBC connections to several other computers. For some reason, this one will not accept the ODBC. Once I get past the login and password area and click okay, I get a login...

I used search results and typed in .mdb to locate all access files on my drive. It lists the following fields: Name and In Folder. Here is my question. Is there a way to generate a list from the search location without doing a print screen??

This is a combination crystal and SQL issue: I created a VIEW in enterprise manager to capture a payment based on date and type. Here it is SELECT giftkey, giftid, gifteffdat, giftamount, giftplgkey, gifttype, giftclass2, giftclass1, giftacctgp FROM dbo.gifts WHERE (giftclass2...