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!

Recent content by rradelet

  1. rradelet

    How to suppress a field in select statement if it is equal to a second field in the same table

    Thank you Skip. I had been trying to use the case function, but I was little bit out on the exact syntax.
  2. rradelet

    How to suppress a field in select statement if it is equal to a second field in the same table

    If am trying to run a simple select query from one table: SELECT FIELD1,FIELD2 FROM TABLEA FIELD1 FIELD2 Blue Red Green Green Yellow Yellow Orange Purple Black Black but if FIELD2 is equal to FIELD I want the result to look like: FIELD1 FIELD2 Blue Red Green Yellow...
  3. rradelet

    Include Double Quotes in concatenated text string

    Using CR 8.5 with a SQL 2000 database I am trying to concatenate strings that include double quotes ("). The string that I want to display in the report is: "text1" "text2" I have tried ""text1"" & space(1) & ""text2"" but get the error message: The remaining text does not appear to be...
  4. rradelet

    Create Stored Procedure to combine 2 tables for use in Crystal Reports

    Thanks so much George! I have had false starts with learning stored procedures before. The examples in books and online tutorials are usually too basic to be of much use. The existing sp's in our database are at the other extreme: far to complex for me to understand how they work. With your...
  5. rradelet

    Create Stored Procedure to combine 2 tables for use in Crystal Reports

    George: Thanks for the reply. Here are some answers to your questions: 1) "Specifically, will the data be filtered by Order Number and/or account number?" I probably won't be doing any other filtering besides the date range. I am trying to produce a report that lists sales grouped by...
  6. rradelet

    Create Stored Procedure to combine 2 tables for use in Crystal Reports

    I am new to SQL Stored Procedures. I use Crystal Reports 8.5 to run reports on a SQL2000 database. The company's order records are stored in 2 tables: "Orders" and "ArchivedOrders". I want to be able to create a SQL Stored Procedure that will prompt the Crystal Reports users for FromDate and...
  7. rradelet

    Access Make Table Query

    Thank you Skip. I was able to create what I needed. I changed the Select statement from: SELECT A.ID, B.ID, A.`Desc`, B.`Desc` to SELECT B.ID, A.ID, B.`Desc`, A.`Desc` and was able to produce data that matched my sample result exactly. I have never used MS Query before, but now see where...
  8. rradelet

    Access Make Table Query

    I am trying to build a make table query in Access 2000, but don't really know how to start with this one. Starting with a table that is composed of two fields: ID: Long Integer Desc: Text Sample of Data: ID Desc 1 1A 2 2A 3 3A 4 3B 5 4A I want to make a table that...
  9. rradelet

    Populate Access Table with Same number of records for each integer

    It now works perfectly. Thanks so much. I am still kind of a novice with Access queries, so you have saved me hours of copying and pasting.
  10. rradelet

    Populate Access Table with Same number of records for each integer

    This first query works, but when I run the second query, I get "Enter Parameter Value" prompts: 1: qsel500_1.Nums 2: qsel500.Nums
  11. rradelet

    Populate Access Table with Same number of records for each integer

    I have a simple Access 2000 table that contains one numeric long integer field with 0 decimal places. I am trying to populate the table so the count of the number of records for each integer between 1 and 500 is the same as that integer (1 row of 1, 2 rows of 2's, 3 rows of 3's etc): Row 1 1...
  12. rradelet

    Filter non-existent ranges from a Min/Max query

    AKelly: Thanks for the reply, but your query just produces a list of all the records in descending order. What I am trying to generate is a list of all of the ranges based on the ranges of the 6th character for the first 5 characters. For the records: V6M1C1 V6M1C2 V6M1C3 V6M1C4 V6M1C5...
  13. rradelet

    Filter non-existent ranges from a Min/Max query

    I guess what I should have said is that I am trying to produce the min & max for consecutive ranges only. Using the min & max grouping was the closest way that I could think of to get the result I am trying to create, which is a from/to list of the ranges of valid postal codes.
  14. rradelet

    Filter non-existent ranges from a Min/Max query

    From an Access 2000 table of Postal Codes, I am trying to run a query will display the minimum and maximum ranges of the postal codes, but not include any invalid ranges in the min & max. Example: [POSTAL_CODE] V6M0A1 V6M1A0 V6M1A1 V6M1A2 V6M1A3 V6M1A4 V6M1A5 V6M1A6 V6M1A7 V6M1A8 V6M1A9...
  15. rradelet

    Find existing ranges of an alphanumeric string field

    LB: There are probably too many records for an array. In the table, the distinct count of left({table.postalcode},5) is over 14,000. There is a city field in the table, so the export could be done in several runs, selecting by city or range of city names, but the distinct count of...
See more

Part and Inventory Search

Back
Top