Search results for query: *

Of course my experience with Access is limited so I'm not quite sure how to go about it. Variables? update while?

The reason this is being done is because the company is updating to ACT and ACT just uses one big memo field. What they'll do is import this one... I've done the basic concatenation... Now I need to account for empty fields & put in return characters: UPDATE [W-SALES WORKING AREA] SET...

I need to update an Access table with 10 date fields and 10 text fields into one big memo field. I also need to have a separating line between. 02/24/2006 - Left Message (new line) 02/25/2006 - Client said to call back (new line) Thanks Elena

My post is incorrect on the code. I changed it to openreport after reading an archive post.

I have set up a query and a form. When I run them independently, they run fine. (I used a sample setup from Access help). The report will not run properly though. It brings up the form, then asks for the parameters to be input as well. Please help! Elena I created a report that has an...

Thanks soooo much everyone. Most of these worked like a charm! Elena

I am trying to pull the 2 characters to the left of ".CSV" Here is the code I have, but it's not working. Please HELP! Thanks Elena REPL ALL KEY with LEFT(ORIGIN,2 at('.CSV',ORIGIN)) Number value changes.... ie:(SERVICE 37.CSV, SERVICE 21.CSV)

That code didn't work. I had to break down and use the cursor due to time restraints. Below is the working code though. Hopefully someone will be able to utilize it down the line somewhere. If somebody does know of some way to accomplish the below without a cursor, please let me know. Most...

Hi, I need to update the top 20 percent records within a 50 mile radius inside the file with an "A" in the keycode field. The catch? It needs to start at the top 20 percent when the dealer # changes. I haven't really started much because I'm being told the only way is a cursor and I really...

I stand corrected and totally embarrassed... I'm testing it right now on 33 million records. Had to tweak it obviously, but the core code was right there. Thanks a bunch! Elena

The code you have above still brings up all the records... What I am trying to achieve is a list of dealer numbers and the date that the feed was missed (which consequently would not be in the file since it wasn't pulled). So if we looked at the sample data I put out here you notice that we...

The structure for the tables are quite large and the below are the only ones we are working with... I hope this is what you need. I know I have major errors in my code. I am just starting on it and trying to come up with something on a short time scale. Thanks for your assistance...

I've also created a stored procedure from one of the threads I've seen. Does this make any sense and would it accomplish a portion of my goal? Create Proc uspMissingdates @start datetime ='2005-04-01', @end datetime ='2005-06-01' As Select @end=cast(cast(@end as datetime)-1 As varchar(8))...

Hi all, Have a nasty little problem here. I need to generate a report that shows where our missing feeds are. There are 163 dealers and each sends us a daily feed. The report should tell us the dealer number and the dates where there is a gap. I'm not quite sure which way is going to be the...

I'm exporting directly from a foxpro table. The example I dropped in is the end result when I type in copy to filename.txt deli with | or export to filename.txt type deli with | Is there a command to export directly to the file without it calling the commas in between the fields?

I am trying to export a file pipe delimited without the commas between each record. Example of how the record should look DP|22780|BRENNER ||RUTH||DOE||RUTH DOE|41 DOE RD||POWER CITY|PA|19980|9446|41|7|||||||OL|NINETY-EIGHT|1995||||C||64830-2|2|6678057525|5A Example of how it is exporting...

UPDATE clientdata_temp SET query_id = 'DUPES' FROM clientdata_temp t1 WHERE uniqueid <> ( SELECT MIN(uniqueid) FROM clientdata_temp WHERE filecode = 'client data' AND lastname = t1.lastname AND address1 = t1.address1 AND zip = t1.zip...

BEFORE DEDUPE: UNIQID FCODE QUERYID LAST ADDRESS ZIP 83378 P NULL ABBOTT XXX CABOT 05647 365237 DMS NULL Abbott XXX CABOT 05647 AFTER DEDUPE: (HOW IT LOOKS NOW): UNIQID FCODE QUERYID LAST ADDRESS ZIP 83378 P NULL ABBOTT XXX CABOT 05647 365237 DMS DUPES...

Answers: 1) There could be duplicates within the client data that would have to be coded 2) Sometimes we only have client data and nothing purchased 3) Uniqueid will never be duplicated...

No duplicate query_ids. Duplicate Names in the file. We have to keep the original data intact so I just code the query_id field with the word "DUPES" when it encounters a duplicate record. As you can see below, it is finding the Purchased data first due to the uniqueid field that is used...