DataBase - 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
Access 2003
(1)
City
(1)
GEOCODE
(1)
COULDER
(1)
005000
(1)
045000
(1)
SAFIRE
(1)
AMT
(1)
Steve Schapel replied to Dave
Dave,
Do you mean that all of the data you showed us is all in one field?
--
Steve Schapel, Microsoft Access MVP
Populate fields in an Access form DataBase Im working in MS Access 2003 I have 8 fileds customer name, contact name, street address, city, etc. . . I need to have the acct number combo box to populate the form once the appropiate number is selected. Can anyone help? Access Forms Coding Discussions Access 2003 (1) Report (1) ContactName (1) CustName (1) AcctNo (1) Combobox (1) kms, When filling in any subsequent form, query or report. On my website (below) I have a 97 and 2003 sample file entitled so that all the ancillary data "displays" on the form. - - hth Al
Field Names with Spaces DataBase Access 2003 - My brackets aren't working. I have the following piece of code: With Me.RecordsetClone .AddNew ![MTNumber] = Me.[MTNumber] !Address = Me.Address ![City] = Me.[City] ![Postal Code] = Me.[Postal Code] It keeps failing every time it gets to a field tried with and without brackets and it still fails. Any ideas? Thanks in advance. ~Dorci Access Modules DAO Discussions Access 2003 (1) MTNumber (1) Database (1) PostalCode (1) AddNew (1) Dorci (1) City (1) Recordset (1) The above syntax, with the bracketing, is correct for fields with spaces
Merge Ltr in Access DataBase I am using Access 2003 I am crearing a merge letter in Access. For the address - there are 3 lins: Add line 1, add line 2 and one line with City, St & Zip. I have it set up as follows: Add 1 Add 2 City-State-Zip When there is no Add line 2 data this leaves a blank line 1 and add 2, this runs everything together in one line. How do I get Access to delete add line 2, if there is no information in the field? Aurora Access Reports Discussions FirstName (1) AuroraUse (1) LastName (1) IIF (1) DEWEY (1) KARL (1) Access
lookuptables nachschlagefeld msysrelationship DataBase hallo, MS Access 2003 ich habe dem Feld "City" in "Invoice" eine Nachschlagtabelle "cities" zugeordnet. Das funktioniert auch. Aber eine Nebenwirkung tritt auch ein ich gerne Dokumentation über msysrelationship Wo finde ich diese? Vielen Dank für eure Hilfe Markus Access Discussions Access 2003 (1) Excel (1) RowSourceType (1) TableDefDim (1) RobertSub (1) FieldDim (1) PropTest (1) Nachschlagefeldern (1 operierst. Kann ich Dir nicht beantworten. Aber warum? Diese Tabelle ist eine Systemtabelle, in denen Access Eigenschaften Deiner DB speichert. Eigentlich brauchst Du gar nix darüber wissen. HTH Thomas - - Hallo Markus Ohlenroth, Markus Ohlenroth schrieb folgendes: lese: http: / / team-moeller.de / access / tiptrick / performance.html#SubDataSheet Gruß Gunter - - _ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ _ Access FAQ: http: / / www.donkarl.com home: http
Avoid Dups DataBase Access 2003 I am attempting to append customer records to a table and avoid duplicates. I made the table with a unique index consisting of: First Last Address Address1 City State Zip After I import records from an existing mdb, I repeat it from the then it allows a dup. When do I need to change. Thanks for your help. Access Discussions Access 2003 (1) Bontrager (1) Dups (1) City (1) Nulls are the big difference between a unique index and a primary key. If means all your existing data in those field must not have nulls in it. Also Access will not allow you to import a record that has a null in it. Often