Access 2003
(1)
City
(1)
GEOCODE
(1)
COULDER
(1)
005000
(1)
045000
(1)
SAFIRE
(1)
AMT
(1)
extract data using a macro?
Asked By Dave
20-Nov-09 05:16 PM
I have about 97000 records. THis data is in the format below: All I
need
is the following elements extracted from this data :
City Name ------------------------------> Only Need the Name
of the city in this case COULDER
TAXABLE AMT ------------------------------> Only need the first
amount in this case 267.40
TAX AMT -------------------------------> Need the first 4
amounts in this case 12.03 1.34 10.70 0.00
I have Access 2003 Every Record is divided by the CITY data item.
the data is as below:
thanks in advance
CITY: COULDER COUNTY: SAFIRE GEOCODE: 37-011-0822 STR: COMPANY-CD:
0010 DIVISION-CD: CUST-CD:
EXEMPT CERTIFICATE #:
INV: 9002220111 DATE: 08/13/20005 LINE: 00020 PROD-
TAX RATE/TYPE----- .045000 S .005000
GROSS SALES------ 267.40 267.40
ZERO RATE AMT---- 0.00 0.00
TAXABLE AMT------ 267.40 267.40
TAX AMT---------- 12.03 1.34 10.70 0.00 24.07
Then The Next City Will come up and so on & on, what could I do ? I
would appreciate it greatly if someone could do a macro on it.
thanks
Dave,Do you mean that all of the data you showed us is all in one field?
Steve Schapel replied to Dave
20-Nov-09 10:09 PM
Dave,
Do you mean that all of the data you showed us is all in one field?
--
Steve Schapel, Microsoft Access MVP
below: All I need is the following form the data : City Name - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -> Only Need the Name of the city in this case COULDER TAXABLE AMT - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -> Only need the first 12.03 1.34 10.70 0.00 I have Access 2003 what I would like if possible is to read this extract the above information Every Record is divided by the CITY data item. the data is as below: thanks in advance CITY: COULDER COUNTY: SAFIRE GEOCODE: 37-011-0822 STR: COMPANY-CD: 0010 DIVISION-CD: CUST 34 10.70 0.00 24.07 Then The Next City Will come up and so on & on, what couould I have asked the same question multiple times. - - Steve Schapel, Microsoft Access MVP keywords: Help, please description: have loaded about 97000 records below: All I need is the following form the data : City Name - -- -- -- -- -- -- -- -- -- -- -- -- -- -- - On
I need is the following elements extracted from this data : City Name - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -> Only Need the Name of the city in this case COULDER TAXABLE AMT - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -> Only need the first 12.03 1.34 10.70 0.00 I have Access 2003 Every Record is divided by the CITY data item. the data is as below: thanks in advance CITY: COULDER COUNTY: SAFIRE GEOCODE: 37-011-0822 STR: COMPANY-CD: 0010 DIVISION-CD: CUST 34 10.70 0.00 24.07 Then The Next City Will come up and so on & on, what could I showed us is all in one field? - - Steve Schapel, Microsoft Access MVP keywords: extract, data, using, a, macro? description: I have I need is the following elements extracted from this data : City Name - -- -- --
below: All I need is the following form the data : City Name - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -> Only Need the Name of the city in this case COULDER TAXABLE AMT - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -> Only need the first 12.03 1.34 10.70 0.00 I have Access 2003 what I would like if possible is to read this extract the above information Every Record is divided by the CITY data item. the data is as below: thanks in advance CITY: COULDER COUNTY: SAFIRE GEOCODE: 37-011-0822 STR: F7-011-0840 F 37-109 34 10.70 0.00 24.07 Then The Next City Will come up and so on & on, what couould I start that you can follow - - SELECT Mid([BigField], InStr([BigField], "CITY: ")+6, InStr([BigField], " COUNTY: ")-(InStr([BigField], "CITY: "))-6) AS CITY, Mid([BigField], InStr([BigField], "COUNTY: ")+8, InStr
DataBase How can I get Yahoo Geocodes into Access? I want to get a list of geocodes into my out how to 'convert' the excel rows looping into my Access recordset. There's more that I can't figure out the data in it that you want to bring into Access, then perhaps I or someone else can assist you further ISP, to upload a small .xls file? Tom Wickerath Microsoft Access MVP http: / / www.accessmvp.com / TWickerath / http: / / www.access.qbuilt.com / html / expert_contributors.html _ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ _ Tom, Try this: http 1. pull a set of addresses from a query 2. geocode them with Yahoo's geocoder 3. write the Lat and excel rows; but I want to 'translate' that action into Access records (fields). regards Eric Hi Eric, I downloaded the spreadsheet for your three test records. I attempted to click on "Geocode all rows", but I get prompted for a Yahoo ID should be able to easily get these values into your Access table. I highly recommend that when you export your query in Access, to create the spreadsheet that needs the latitude and longitude
DataBase Access 2003 - -- Access 2007 Runtime Conflict Background Several people at our firm in Department ???A??? use Access 2003 to work with an older Access 2003 Database. This system has worked nicely for several years. We system for Department ???B???. The people in this department use Access 2007 Runtime. This works nicely for them. Recently a person in Department ???A??? wanted to use a component of the Access 2007 system that was build for Department ???B???. We downloaded Access 2007 Runtime for this person. They now can use the
DataBase MDB (Access 2002-2003) file format in Access 2007 Access Learner. Access 2007. If I create a database in Access 2002-2003 file format in Access 2007 and then split the mdb file into BE and can I use copies of the same FE in both Access 2007 and Access 2003? Or I have to modify it to use it
DataBase Pivot table in Access 2003 In MS Access 2003, we can create an pivot table. Can I convert it to a Report in Access 2003. Ben keywords: Pivot, table, in Access, 2003 description: In MS Access 2003, we can create an pivot table. Can I convert it
DataBase Access 2003 Setup erstellen - Access 2003 Developer Extensions Hallo Allerseits, ich würde gerne für eine erstellte Accessdatenbank A2003 ein Setup erstellen. Hierfür habe ich mir die "Access 2003 Developer Extensions" von microsoft runtergeladen, Aber schon bei der Installation der "Access 2003 Developer Extensions" kommt die lustige Fehlermeldung: nicht korrekt installiert. Setup wird nun abgebrochen. Sie sollten die Access-Entwicklererweiterungen installieren oder die vorhendene Installation reparieren und anschließend Setup der selbe Fehler. Ich habe auf meinem System Windows XP Access 2.0 Access 97 Access 2000 Access 2003 installiert wer