Search results for query: *

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

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

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?

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

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

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

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.

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?

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

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.

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

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

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

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

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