Search results for query: *

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

LB: The new formulas give the correct result, but the maximum length for a string field is 65534 characters. Breaking the selection down into small chunks works, but I what I am trying to do is to export the min & max records as 2 different fields into a new Access table,or and Excel or CSV...

lbass: "A string is required here" error now occurs at: maxrange := 0; if maxrange <> 0 then I tried changing these to: maxrange := ""; if maxrange <> "" then and can now run the report, but the Min values aren't right For example: V6B0A1 V6B0A2 V6B0A3 V6B0A4 V6B0A5 V6B0A6 V6B0A7 V6B0A8...

lbass, Thanks for the reply. I hadn't used the previous or next functions before, but I think I understand how they work. I tried your formula, but can't get it to work: 1) After line #9 "{table.postalcode} <> previous({table.postalcode}) + 1" I receive a "A string is required here" error...

From an Access table of Postal Codes, I am trying to run a report in Crystal 11 that 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 V6M1A1 V6M1A2 V6M1A3 V6M1A4 V6M1A5 V6M1A6 V6M1A7 V6M1A8...

Thanks for the suggestion. This does work, but the table I am working with has over 200 distinct PriceID's, which would make for quite a cumbersome report. Are there any other ideas how to approach this.