Different destination fields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi All,

I've got 2 fields in my database that represent Easting and Northings. Due
to the way the client's db is set up, I need to append each of these values
to one of 2 fields in the destination table (UTM_Easting or Grid_Easting).
UTM's are the full 6/7 digits while Grid coordinates are usually 3 digits
each. How would I build the query so that it would be able to determine if
it should go to UTM_Easting or Grid_Easting?

Thanks
.

Relevant Pages

  • Append truncates some text fields
    ... When I append a text field from a staging table to the master table, ... The field is not indexed in the staging table. ... field for all records in the staging table is exactly 9 digits. ...
    (microsoft.public.access.queries)
  • Re: Append truncates some text fields
    ... I would check the Format and Input Mask properties. ... The field is not indexed in the staging table. ... The append query is a straight append ... field for all records in the staging table is exactly 9 digits. ...
    (microsoft.public.access.queries)
  • numbers rounding up in table
    ... I have several tables that have numbers displaying 2 digits to the right of ... However, when I append these into a common table, all numbers ...
    (comp.databases.ms-access)
  • Re: How to manipulate a contents of file as record structures
    ... and append the sum of digits at the end. ... Gabriel Genellina ...
    (comp.lang.python)