Search results

  1. C

    Change date format display in mail merge document

    When mail merging from an Access 2000 database into Word 2000 date fields are shown as dd/mm/yy in the merged documents. I would like them to display as mmm-yyyy in these merged word documents. The date field is set as medium format in the database table and displays as dd-mmm-yyyy How do I...
  2. C

    Auto-incrementing number in field containing non sequential numbers

    In a pre-existing Access 2000 club membership database I have a column called 'membership_No' The pre-existing membership numbers are not all sequential (many numbers are missing) and the field is not auto incrementing. As there is already data in this field I can’t change it to be...
  3. C

    how do I convert numbers in a text field to dates in Access 2000

    I am working with a SQL club membership database that was setup by someone else. When imported to my PC the date fields are set as text and displays numbers(yyyymmdd) instead of date fields. Membership is annual and determined by month joined and I need to be able to contact members due for...
Back
Top Bottom