Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2001
    Posts
    46

    Unanswered: Help ! How to Randomize field

    I have 1 table named tblCASE

    tblCASE
    =====
    CASE_ID --- (Autonumber)
    VISIT_NUM
    PATIENT_ID

    I want to make my VISIT_NUM change according to CASE_ID say
    =CDate(Date())+[case.case_id]
    is it posible to call that?

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    ummm, yes.

    you can set the default value for a field to anything that is defined at the time Access tries to set the default (e.g. a global function returning a string composed of currently defined things): i didn't look into whether the autonumber is "defined" in time for access to allow you to use it in an expression for the default value of a field in the same record under creation...

    ...but...

    ...why would you want to do what you say you want to do?

    you can create your VISIT_NUM on the fly (sorry if this doesn't translate correctly!) any time you need it from the CASE_ID and some FORMATTED_DATE field [based on for e.g. default = now()].
    this not only saves you the hassle of finding out how to code up your VISIT_NUM, but it also greatly simplifies potential future searches by date.

    better still - date & long normally take less space that text.

    izy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •