Search results for query: *

1. I created a macro that sends an rtf file to two people 2. I created a form as a startup, added a control button and linked it in events to the output macro in step1 3. In tools startup I added the macro name I gave it in step 2. 4. In task Scheduler I scheduled the macro to run using MS...

I have the following fields giftkey(numeric) giftid(char) giftmkr(char) I have the following query select a.giftkey,a.giftid,a.giftmkr b.giftkey,b.giftid,b.giftmkr from gifttable a left outer join gifttable b on a.gifkey=b.gifthrnkey here is an example of what I get a.giftkey a.giftid...

Using php admin (server side) I have the following code insert into admin values ('','Smith','smith_gr ',password('tlc84')) ; I have done this several times. I general get the name and an encrypted password resembling a hexidecimal numeric sequence. Now I get a long number like this...

Is there a way to add a primary key after the fact to an sql view. I designed a view in QA then dumped the results into an sql view. Now I want to go back and establish the giftkey as the primary key. Is there a way without a re-design???

The following query, done in QA, totals the sum of giving for a particular account number. It will list each gift separately and insert the number of years that elapsed when the gift was given. In my case, the account number made 3 gifts in the first year or no_of_years. Here are my...

I have the following formula totext(Sum ({@giftamt}, {gifts.giftacctno}),0,"") It returns a number similar to this: $8720. Thus I successfully removed the comma. However I want to remove the dollar sign and add two decimals at the end. Thus $8720 becomes 8720.00. How would I accomplish this?

What is the best way to display a date range when you know which date range you want and then do a booleon based on that range. Here is my example. I have a field called gifteffectiveDate. For each transaction if the gifteffective date occured between 07/01/2007 and 06/30/2008 I want to...

I have a rather large sql query that pulls from 4 different tables with left outer joins. The table also has a grouping due to a total. here is a snipplet of the view (note I did the coding in SQL Analyzer then copied code into a view) select name,addr1,addr2,city,jobname,sum(giving)as...

I have sample code to be used in a conncetion string for an Access table using dreamweaver as an editor. When I preview the webpage on my local server, 1. I get an error message. Compiler Error Message: BC30451: Name 'RS' is not declared. Line 10 creates the error. Line 10: Do While Not...

Using sql 2005, I have 2 fields, bioID and MillID. I want to create and populate another field, lets call it Combine. If the contents of bioID equal MillID then I want to print 'N', else if the contents of bioID are not equal to MillID I want to populate the same field with a 'Y' So far my...

I used the upsizing wizard to upload an access table to sql. Lets call the table mytable1. I set permissions to alter, delete, insert, select, and update. I went back into MS Access, I chose File, Get External Data, Link Table. I then linked the mytable1 and brought it in as a table. I went...

We are about to use crystal reports 10 or beyond to create reports and deploy them using a scheduler. They are to be web based reports and we have chosen dreamweaver as the editor. 1. If you are running windows xp, doesnt microsoft provide a method of installing an IIS server on your local...

I am using crystal 9 and attempted to do a forced page break. Presently, I have to go into the filter area and type in the desired account number. The report is a crosstab and the data is in the report footer. The report lists several account numbers. I want to force a page break after each...

I have a very large file (123,000) records that cannot be exported out of crystal through excel because excel has a 65000 record limit. I chose csv file for exporting. The headers at located at the top or Report Header. When I export using csv I get the file okay. However after each line the...

I have an access query. I pull in the name.ID and link it to the school_table.id. Here is the issue. A person can have more than 1 school degree (which is taken from the school_table) I want to show the name.ID one time or distinct. In an access query, I want to show all the degrees...

I have a text field called corebirthyr. I want to subtract it from year(currentdate) which is a numeric. I converted the corebirthyr to numeric tonumber({corebirthyr}). I then created a formula subtracting corebirthyr from year(currentdate) with the purpose of getting the numeric age. I keep...

I import an access table that formats the zipcode as follows: For 23225-0522. It reads 232250522. In an update query, how can I format the zip code so that if it is 9 digit, it will read 23225-0522? If it is a 5 digit zip I need it to read 23225 with no dash at the end.

I have an access table with a large file. In access, I am trying to export it to a .txt file. The first 3 columns look fine. ( I used comma separated delimited) When I get to the forth column, the data jumps several carraiges to the right. I believe there is a problem with the column because...

I am trying to export an access table to a .dbf file. It is a large file (89000) records. None of the field names are the same but I am getting an error, Cannot define field more than once (error 3191). In looking at the field names none of them are the same name, although some of the names...

SQL by default displays instances of data vertically. I have a situation where I have a gifthrnkey and giftid. If there are multiple gifthrnkeys and giftid, I want to list the output horizontally. For example in a normal sql query of select gifthnrkey,giftid from gift_table, the output would...