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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: wsproperties
  • Content: Threads
  • Order by date
  1. wsproperties

    scheduling acess query to run

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

    Crosstab in SQL

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

    password encryption

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

    Adding Primary Key to an SQL View

    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???
  5. wsproperties

    Grouping and totaling by date in SQL Issue SQL2005

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

    Remove Comma, show decimals

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

    Date Range Question

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

    SQL Query Times out before completion

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

    Connection String Using asp.net and Dreamweaver

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

    If then and add a field in SQL

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

    Uploaded Access Table to SQL Issue

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

    SQL Server and Deplpying Reports

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

    Forcing Page Break by selection

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

    Headers Repeat themselves when exporting

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

    showing distinct records with all school information

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

    Calculating difference - date vs numeric

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

    Zip+4 in an update query

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

    .txt file acting funky

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

    cannot define field more than once

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

    SQL Horizontal display

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

Part and Inventory Search

Back
Top