Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by hawg9

  1. hawg9

    Delete Query

    I have a set of values in table NPANXX and need to delete records in Table 2 where Field A in NPANXX equals Field B in Table 2.
  2. hawg9

    Formatting a Date field

    I have a date field that is showing dates in the following format: 1/9/2006. I need it to show with a two digit month and day and then be converted to YYYYMMDD format.
  3. hawg9

    Adding a set number of days to a date field

    How can I convert text to a date so that I can add 30 days to it?
  4. hawg9

    Adding a set number of days to a date field

    How can I add 30 days to an existing date field
  5. hawg9

    Text field to a Numeric field with a decimal

    I have a text field (0000000.00000) and I need to convert it to a numeric field. I have tried Int(Field Name) and set the properties to Fixed with a decimal value of 5. When it converts, it places all 0's after the decimal point.
  6. hawg9

    Date Difference

    The values look like 20051109 and 20051106. I have tried datediff but it did not work
  7. hawg9

    Date Difference

    I have 2 fields that contain dates that are text fields. How can I calculate the difference between the two dates?
  8. hawg9

    Text field that contains a number

    Because I don't have time to try and reconvert at the moment. Do you have any suggestions on how I can get around this temporarily.
  9. hawg9

    Text field that contains a number

    I have a text field that contains a number and I need to multiply it by 100 but it is returning an error. Other than re-importing the data, how can I get around this error?
  10. hawg9

    Date Conversion

    Skip, in addition, i have set these fields to have a default value now and when I run the first query, it should populate the default values. For some reason, some of the fields are not being populated with the default values that I have defined. Do you have any suggestions? Thanks - Chris
  11. hawg9

    Date Conversion

    Will this compensate if there are null values as well?
  12. hawg9

    Date Conversion

    No, not if I can get the format to look correct
  13. hawg9

    Need duplicate records with different field 2 values

    I have two fields (Phone #, add on). I need to create a single record for each phone number and unique add on.
  14. hawg9

    Date Conversion

    Skip, I got a validation rule violation and I think it is because this data is imported into a database as a text field. Do you have any suggestions on how I can get around this other than having to have someone re-import the data and change the field types? Thanks
  15. hawg9

    Date Conversion

    I have multiple fields where the date is imported as M/D/YYYY. I need to find a way to convert it to YYYYMMDD.
See more

Part and Inventory Search

Back
Top