Search results for query: *

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

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

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)

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

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

Below is the code I am currently using to dedupe my data. While this works fine, I am not able to protect my client data and update the query_id on the data I want (purchased data) because SQL has to use the uniqueid field. My data comes in at different times. Purchased lists come in days...

I looked through the posts and saw lots of queries to pull duplicate information, but how would you update a column to tag the dupes? I want to do something like the below although I know this particular one doesn't work.... UPDATE [63805-06] SET QUERY_ID = 'DUPES' from [63805-06] A1...

Hi All, I am trying to write a program that inserts an address multiple times (have 156 names that need the same address according to the qty field). Someone said to use the _tally feature with an insert command and I am not too good with this type of programming. I'm more old school with...

I import this file all of the time through conversion software but now it just died on me. I need to import this data into a dbf file. The beginning of the row and where the data starts for each record is always consistent. Attached is a sample. I'm currently working in programmer's editor...

Need help on the below code. Trying to export 7222 records for each keycode, but the program is only exporting a portion of each. I have the file in dlrnmbr order but it still doesn't work. Anybody see something blaring or perhaps easier coding? Thanks Elena CLOSE ALL CLEAR SET SAFETY OFF...

Hi, I am not well versed in Access although I understand SQL and Foxpro well. How are you able to update a field to proper case? I have tried several times both in the report form and in the actual table to no avail. I'm sure it's simple. I just don't know my way around well enough. Thanks...

Is there an easy little program to append multiple files to one database? The one below is not working very well since there are 280 dat files to append.... FOR X = 1 TO 280 XVAR = GETFILE('dat') APPE FROM ALLTRIM(LOWER(XVAR)) deli Thanks for any assistance!

I would like to delete everything to the right of an '&' ie: John & Sandra (Remove '& Sandra') How would this be accomplished? Thanks for any assistance.

I have a file with address, city state and zip in one field. I see that there are two spaces before it puts the city, state zip info. What would the command be to take all the info to the right of the first occurence of two spaces and put it in another field? Thanks for any assistance.

I am new to Dreamweaver and have been trying to get away from Frontpage. It's so much easier when you have slices. I want to add text on top of one of the slices I created in Fireworks. Do I have to edit the slice in fireworks? If so, how would I add a form then? Any help is greatly...

Is there any way to import a file into visual foxpro that is formatted as labels? ie: Computer User 123 main st anytown, usa 55555 computer user 2 124 main st anytown, usa 55555

I need to pull all customers who have not been serviced in more than 6 months. The catch is that there are multiple activity dates per customer. They might have come in last week so they have one record with a recent date and one with a date more than six months ago. How can I structure the...

Hi. I am receiving a file from a client on an as400. Each master record can have infinite number of transactions in it. Fields 1-42 are the master and then 5 fields for each transaction until you reach a break code that says you've reached the next master record. Sample client data: YNNNNN...

Hi, I am taking over some code that someone has written. I am getting an error when I try to update the table. "Invalid delimited data: text qualifier must be followed by a column delimiter (except the last column)." The file is a tab delimited file and when I look at everything...