extract data using a macro?

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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
 
Back
Top