Search results

  1. A

    Changing data type with sql

    Ah, okay. Thanks! So how would I set up the precision and scale in integer using sql? Everything I've tried comes back with a syntax error...:confused:
  2. A

    Changing data type with sql

    Can anyone help me with the sql for changing a datatype to decimal, precision 9, scale 2? I'm pretty new to sql and seem to be banging my head against a brick wall at the moment! Many thanks.
  3. A

    Adding a field to a table through a query

    thank you!
  4. A

    Adding a field to a table through a query

    While downloading information from Banner into an Access table, a couple of fields that aren't needed at that point, are knocked out of the table and need to be put back in manually. Is there anyway this can be done with a query? Also, Banner changes a couple of data types as well later on in...
Top Bottom