Search results for query: *

Golom -- sorry I was confusing. I meant that I could not figure out a way to get the replace function into a query. But I need a query because I can not restructure the world right here at crunch time. PHV -- I will be investigating your methodology during my lunch hour and get back. Thanks...

Yes, but I can not do it in a query. And I run a number of queries for this database don't want to change the game here at crunch time. ::-) Deb Koplen deb.koplen@verizon.com koplend@swbell.net (weekends and nights) A person can stand almost anything except a succession of ordinary days.

I need a query that will look for "-" anywhere in a number and delete them. Example: 8888-88-4444444 or 8888-88-4444444 8888884-44-44-44 to 8888884444444 I would really like to do this in a query if at all possible and I did not find anything that would work when I searched on replace. ::-)...

My entire department will be upgrading to 2003 early in 2005. one thing that would cause me to expedite the process would be if the following "questionable practices" in 2000 have changed 1. Can you export Reports in anything other than RTF so that graphics can be pasted into PowerPoint? 2...

AH HA -- Using MS Query. Hmmmmm. Never thought of that. ::-) Deb Koplen deb.koplen@verizon.com koplend@swbell.net (weekends and nights) A person can stand almost anything except a succession of ordinary days.

How do you get 72 into 20? With a lot of time spent in setup. I have one workbook, and in that workbook is a sheet labeled "DataMaster". Data Master is linked outward to the 72+ queries generated from Access. And then the 20 worksheet pages are linked to the "DataMaster". Since they are...

I am exporting 72+ queries from Access to Excel to update 20 Excel charts. And the charts have to be in Excel. I need to do whatever is possible to speed up the process. And this would be one step. ::-) Deb Koplen deb.koplen@verizon.com koplend@swbell.net (weekends and nights) A person...

One of the glitches in Access 2000 is that when you export to Excel, it exports in 5.0/95 format. To get it into Excel 2000 format (so that it can be linked to), you need to save it using the "disk" or "save as". You can not just close it. When I wrote a macro to save it, it saves it in...

I know that Access 2000 exporting to an Excel 5.0/95 Workbook is a known problem (hope it got taken care of in 2003 [ponder]). However, it is usually not a problem, but I have this situation where I need to export 45+ queries to Excel every month to feed a bunch of graphs. AND I NEED TO SPEED...

I know that this has been discussed, but I can not find the information [sadeyes]! What is wrong with the following If [subform DATA_ACE Claims A].[BTN] Is Null Then [subform DATA_ACE Claims A].Visible = False Else [subform DATA_ACE Claims A].Visible = True End If I get "Run-time error '438...

I can create custom stationary with no problem, and get a picture in. BUT I want the picture to show like a letterhead, and none of the message to start on top of the picture. I have "sorta" accomplised this by making a large, blank picture and putting my "letterhead" picture at the top...

Is there anyway that I can do a search and replace with a query? I need to remove all NON-alpha/numeric characters. Example: 456-444*777 to 456444777 ::-) Deb Koplen deb.koplen@verizon.com koplend@swbell.net (weekends and nights) A person can stand almost anything except a succession...

I need to run a query that tells me if a field has less than 10 characters. Any ideas? ::-) Deb Koplen deb.koplen@verizon.com koplend@swbell.net (weekends and nights) A person can stand almost anything except a succession of ordinary days.

Brillant! AnD so simple Thanks so very much for working with me on this!!!!! ::-) Deb Koplen deb.koplen@verizon.com koplend@swbell.net (weekends and nights) A person can stand almost anything except a succession of ordinary days.

I had sorta stumbled into your second version and came up with SELECT DnbGlobalultname, billing_system, customer_name, account_status, [CU MO Current], [CUR MO 91+], [CUR MO TOTAL] FROM [DATA_Top Ten with charges] AS t WHERE ((([CUR MO 91+]) In (select TOP 10 [CUR MO 91+] from [DATA_Top Ten...

I am trying, but do you mean top 10 revenues for each customer? ::-) Deb Koplen deb.koplen@verizon.com koplend@swbell.net (weekends and nights) A person can stand almost anything except a succession of ordinary days.

MORE. . . Because I have over a million records to process, I am trying a two step process. FIRST: A query that list the top ten customers. Second: Based on First query, a table that lists all of the orders for the Top Ten customers with the data required. NOW, using the Table as a base, is...

Selecting the basic top ten is not the problem. However, I need to select the top ten customers by revenue, then the largest ten orders for each of those customers. I know that I could do it with 11 queries then joined with a union query. BUT, the data can change monthly and would not like to...

The No current Record problem seems to be related to the type of JOIN, but I can not get the data I want when I use the inner join. AND, if I take out the information about the Duplicate record (see bold) I also get records. The following returns NO CURRENT RECORD SELECT [REF_Dashboard...

I am sorry that I have not got back to you, nor tested your solution, but I have been down with the crud and am posting this from home. As soon as I get back to the office, I will test your solution and probably come back with more questions. ::-) Deb Koplen deb.koplen@verizon.com...