Recent content by Freckles

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