Recent content by rradelet

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

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

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

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

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

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

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

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

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.

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

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

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

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.

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

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