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 Rhinorhino 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: *

  1. geckodfw

    Need To Print Specific Single Label

    Help! I need to be able to navigate to a form, then print a video tape SPINE and video tape FACE label from that record. The idea would be to put the 2 label sheets in the printer in advance, then just have both of them print out. I only need ONE label printed at a time, and I need to...
  2. geckodfw

    Infomaker Concatenated Field Over 255

    I have to produce a flat file for a customer. The requirements for the file exceed ANSI standard of 255 characters per field. I need this report to generate a record that is one field of concatenated information that is 278 characters long. I know I can't do this on our server. I need an...
  3. geckodfw

    change number to text for join

    I have 2 tables that I need to join, one table has a field called "Bill_To" which is a number field. It corresponds to another table in the same database where it is called "recv_acct_id" and is text. There is no indexing or calculation needed. I just need the two to...
  4. geckodfw

    TOP 10 Per region

    Here is what finally worked. SELECT p1.region, p1.acct_name, p1.recv_acct_id, p1.conv_amt, p1.over60 FROM top10regions AS p1 WHERE p1.over60 in (select top 10 p2.over60 from top10regions as p2 where p2.region = p1.region order by p2.over60 desc); It takes forever, but it does return what I...
  5. geckodfw

    TOP 10 Per region

    Ok I have this: SELECT q.acct_name, q.region, q.recv_acct_id, q.conv_amt, q.over60 FROM top10regions AS q WHERE (((q.acct_name) In (SELECT TOP 10 acct_name FROM top10regions WHERE region=q.region ORDER BY over60 Desc))); in Access, right now it's returning 610 records, 122 from the first...
  6. geckodfw

    TOP 10 Per region

    I ran into the same problem. When I try to use the "AS" part of the suggestion, Access redefines the table I had based the query on as an empty table called "I". From there it won't work. I am going to peruse the suggestions you gave. Thanks.
  7. geckodfw

    TOP 10 Per region

    SELECT top10regions.region, top10regions.recv_acct_id, top10regions.acct_name, top10regions.conv_amt, top10regions.over60 FROM top10regions ORDER BY top10regions.region, top10regions.over60 DESC; That's the query I have so far, just pulling all 7753 records.
  8. geckodfw

    TOP 10 Per region

    I have been making more attempts at this query, and I still haven't any results yet. I have a table consisting of 7753 records. The records consist of 3 fields, REGION, ACCT, and AMOUNT. I need to query this table to pull out the 10 highest amounts for each region. There are 9 different...
  9. geckodfw

    Show all unless selction...

    I want to be able to select records from the table based on a parameter. If there is data in the parameter, I want only records based on that data returned. If there is nothing in the parameter, I want all the records returned. If the user inputs wants to get "CANADA" they will type...
  10. geckodfw

    Show all unless selction...

    Yes, it's a query in Access 2000. Sorry about that. :)
  11. geckodfw

    Show all unless selction...

    I need a criteria that will show all the records if a criteria is not entered. If the region "CANADA" is entered into a parameter, then show only "CANADA". If nothing is entered into the parameter, show all the records. I have tried IIF(IS NOT NULL, [parameter]...
  12. geckodfw

    multiple conditions to satisfy

    I have a table of about 6000 records with a field called 'territory'. The 'territory' consists of values like "SW", "SW1", "SW2", "NE","NE1","NE2". I made a query called qry_top10_region from this table that creates a 'region' field...
  13. geckodfw

    TOP 10 SELECT SUBQUERY

    I have a table of about 6000 records with a field called 'territory'. The 'territory' consists of values like "SW", "SW1", "SW2", "NE","NE1","NE2". I made a query called qry_top10_region from this table that creates a 'region' field...
  14. geckodfw

    TOP 10 SELECT SUBQUERY

    Perhaps this is a new issue. I have tried and failed. This is the SQL within my Access DB. SELECT qry_top10_region.acct_name, qry_top10_region.acct_name, qry_top10_region.region, qry_top10_region.recv_acct_id, qry_top10_region.balamt, qry_top10_region.over60 FROM qry_top10_region; What I...
  15. geckodfw

    multiple conditions to satisfy

    I have tried and failed. This is the SQL within my Access DB. SELECT qry_top10_region.acct_name, qry_top10_region.acct_name, qry_top10_region.region, qry_top10_region.recv_acct_id, qry_top10_region.balamt, qry_top10_region.over60 FROM qry_top10_region; What I need from Access is the 10...
  16. geckodfw

    multiple conditions to satisfy

    I think that's pretty close to what I need, but I think I'm going to set up a SELECT CASE because not all the Canada's start with "C", etc. You guys are a great help! Thanks so much!
  17. geckodfw

    multiple conditions to satisfy

    I have a table with a territory field, the territories need to be organized by 'region' Such as: EAST1, EAST2, EAST3 all need to be designated "EAST" CAN, CNG, CVT all need to be designated "CANADA" I have tried nesting IIF's with no success, I have also tried using 'OR'...

Part and Inventory Search

Back
Top