Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unanswered: Access : semi-standard-values

    Hello all

    I want to create somewhat advanced database to log my sail-trips.
    I have a logbook with date, departure, crew,... + logs (wind, direction, speed, position,...)per hour

    I often go away for some days:
    Now the problem; how can I combine fields valid for the whole trip (eg crew)with fields which are variable per hour?

    My humble solution:
    I was thinking of; if "today" in a new record is in the interval "departure-arrival" of a previous record, all fields will be copied from the previous record.

    Is this possible in ACCESS?

    Does anyone can help me out of this? thank you in advance

    Michael
    michaelmoorecfm@hotmail.com

  2. #2
    Join Date
    Apr 2004
    Location
    Pune, India
    Posts
    14
    ya it is very much possible. Can you provide the brief of the work that you have done till now..i.e table and fields that you have designed.

  3. #3
    Join Date
    Apr 2004
    Posts
    3
    Hello,

    first of all thank you for your reply.

    this screenshot shows what is configured already.
    Date= Date()

    if Date() is in the interval of "departure/arrival" of an already defined record, all date of the last record should be copied.

    It is a big, big help if this could be possible.

    Michael
    Attached Thumbnails Attached Thumbnails logbook_sailing.jpg  

  4. #4
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    how about something like:

    tblTrips
    idTrip (autonumber, primary key)
    dateOut (date)
    dateIn (date)
    comment (memo)
    ...and anything else that belongs to the trip



    tblPeople
    idPerson (autonumber, primary key)
    firstName (text)
    lastName (text)
    phone (text)
    address1 (text)
    address2 (text)
    dateofbirth (date)
    genderFemale (yes/no TRUE if female, else FALSE)
    ...and anything else that belongs to the person



    tblCrew
    idCrew (autonumber, primary key)
    idTrip foreign key on tblTrips
    idPerson foreign key on tblPeople



    tblLogs
    idLog (autonumber, primary key)
    idTrip foreign key on tblTrips
    windSpeed (integer)
    latitude (single)
    longitude (single)


    izy
    currently using SS 2008R2

  5. #5
    Join Date
    Apr 2004
    Posts
    3
    Hello,

    Thank you for your reply, this could be a solution, but I was more thinking of this approach:

    once I filled out the first record, the second one will be similar (one hour later the crew won't have changed, weather conditions not that drastically).
    But indeed, for the next trip I will have to take care that I update all information.
    Given this, I want the information of the previous record to be set as default (and can be overwritable if necessary).

    Do you know an Access command that makes it possible to take the values from the previous record as default ?

    Michael Moore

  6. #6
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    sorry in advance Michael, i really am trying not to be too nasty:

    almost everything is possible in access, but your confused table would still be a lousy relational database design. no amount of clever code will ever fix inadequate table design.

    think more on my tables suggestion: each log entry "knows" which trip it belongs to... no repeated data, the crew is defined once only for the trip.
    each log entry "knows" who the crew were.
    each crew member "knows" the weather of every trip s/he went on.

    a million log entries per trip, and never a need to restate who the crew were.

    if you are not convinced, post an extract of your db here and someone will recast it in relational format for you --- maybe you dont know what you are missing.

    izy
    currently using SS 2008R2

Posting Permissions

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