Advertise on Bikeforums.net



User Tag List

Results 1 to 1 of 1
  1. #1
    Senior Member DnvrFox's Avatar
    Join Date
    Aug 2001
    Posts
    20,899
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Okay, guys and gals, I am designing an Access 2000 database to compile data from the "Special Thread for 50+ yo bicyclists".

    I have had a lot of experience designing databases in the old Q&A Windows 3.1 and DOS (tells you how dated I am).

    I have only designed one Access DB, and that was some years ago, using Access 1.0

    So, I need one of you DB gurus to take a look at the DB I have designed.

    I do not find Access to be very intuitive, and it also uses language that I am not familiar with, and for some reason typing a help query in the stupid little box NEVER gives me an answer I need, and the index is little better.

    For example, I designed 3 separate entry pages off of the table I created, then I tried to link the pages so that it would automatically go from page 1 to page 2 to page 3 (This was easy and automatic in Q&A) A help search turned up nothing about linking pages, so I redesigned the whole thing on one page - I have about 35 fields or so - and it looks awfully crowded. I thought Access would link pages automatically and sequentially, as it all derives from the same table. I guess I thought wrong!

    Also, I would like to have a main field which if the answer is "no" then you go on to the next field, but if the answer is "yes" you go to a separate group of applicable fields.

    I.e, "Do you take supplements" - if the answer is "NO" then I would not want to see any more on the page; if the answer is "Yes" then I would like a list of supplements to chekc "YES" or "NO" - such as Glucosamine, Vitamin C, - you get the idea. Yet I can find no way to set this up. I can find no "IF" "THEN" operators

    Anyone out there help me design. I would be pleased to email you what I have for your review. It is pretty basic right now.

    Also, I need to design the queries - mean age, modal age, range, Std Dev, etc., and perhaps age of roadies v. age of mtn bikers, etc. Also, compilation of text lists - names of bike brands, etc.

    Average annual mileage vs. years in biking v. age. Stuff like that.

    HELP!
    Last edited by DnvrFox; 10-17-04 at 09:19 PM.

Posting Permissions

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