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

    prioritize duplicates

    Ok, let me start over. Here is a sample of the data: Name Address City Zip Co John Doe 123 Main St 12345 555-1212 1 Mike Fits 542 Joy Ave 12345 555-1212 9 Julie Adams 111 Ellen St 12346 555-1212 2 Tim Eliot 12 Center St 12346 555-2323 9 Mike Mills 5 Main St 12346 555-1213 5 Here's my current...
  2. medic61

    prioritize duplicates

    BigRed, max(Co) may work.....never used it before that's why I'm asking. The sample does have dups, 3 numbers all 555-1212. That's what I want to have it look for and if there are dups, then pick the "Co" that has the largest number to display in my query, my query just shows everything. My...
  3. medic61

    prioritize duplicates

    My original query just returned every record, sorted. The CO was not in the original query because I didn't know how to use it. I don't need it to display, I just need it to find the duplicates. Does this make sense?
  4. medic61

    prioritize duplicates

    So here's my current sql: SELECT Main.Name, Trim([Other]&" "&[Address] & " " & [City] & " " & [Zip]) AS Expr1, Main.Phone FROM Main ORDER BY Main.Sort, Main.Lines; Here's what I changed it to: SELECT Main.Name, Trim([Other] & " " & [Address] & " " & [City] & " " & [Zip]) AS Expr1, Main.Phone...
  5. medic61

    prioritize duplicates

    Yes, Co would be the field i want to use to prioritize the output. so if I had this: John Doe555-1212 Co=1 Mike Fits 555-1212 Co=9 Julie Adams 555-1212 Co=2 Then it should output Mike Fits 555-1212
  6. medic61

    prioritize duplicates

    I thought I posted this yesterday, but don't see my thread, sorry if it's a dup. I have a table of address's from multiple sources. I have a query to pull the info I need, but there are many duplicates. I can't seem to find how to display the results on a priority basis. My source field is...
  7. medic61

    help splitting after x number of chars

    Okay, now I"m totally lost! :-) Don't know if this helps or not, but I need the code in a query so I can export the query as xml.
  8. medic61

    help splitting after x number of chars

    Only worried about 1 line splitting, should never need split more than that. So what exacatly is the code I need to place so that it checks every line in my query when I run it and where do I place it at?
  9. medic61

    help splitting after x number of chars

    I would prefer it to count both the Name and Expr1 when it calclulates if possible.
  10. medic61

    help splitting after x number of chars

    I know it's complex, that's why I need help. :-) I have reviewed that and I'm no where closer. It's all greek.
  11. medic61

    help splitting after x number of chars

    Field 1 is just "Name" Field 2 is combo of "Desc,Weight,Size" Field 3 is just "Price" Sample: Marine Shirt High quality screenprinted with full back and front left chest 1.5oz Large $15.95 I want it to split after 40 characters and spaces to end up with: Marine Shirt High quality...
  12. medic61

    help splitting after x number of chars

    I hope someone can help me with this. I'm printing a catalog of products. I need to export as xml so it can be imported. I have a query in access that is creating 3 fields, prod name, a combo of desciption, weight and size and a price field. I need to count characters in prod name and my combo...
  13. medic61

    xtg file

    I've created a large file using xtg's. Example: <B>John Doe <P>Member <B>555-5555 <B>John Doe <P>Member <B>555-5555 Problem: After the first line, the name does not appear in bold, only the phone number. I know the file has the right header, extension and "styles" is checked, otherwise the...
  14. medic61

    add string and format decimal

    I'll give your suggestion a try! Thanks. To clarify the first point: table: Products Field: ImageURL sample data /images/pic1.jpg I need to add http://www.domain.com/store in front so that when I export as csv, it would show as: http://www.domain.com/store/images/pic1.jpg Would a trim...
  15. medic61

    add string and format decimal

    Fairly new to Access 2000. I have a large database, I need to extract 5 fields from my products table. I then need to format them as to export to a .csv file to then upload to Froogle. I need to add ie. http://www.domain.com/store in front of the image url field. This is need #1. 2. I need to...

Part and Inventory Search

Back
Top