Search results

  1. E

    Check another table and return a value

    theDBguy.... i changed >0 to =0 and it works perfectly. Thank you so much!
  2. E

    Check another table and return a value

    Thanks theDBguy!!!
  3. E

    Check another table and return a value

    I have two tables... competitor_tbl and old_competitor_tbl. When I input data into the competitor_tbl I want the field ssn to check my old_competitor_tbl to see if the inputted ssn is in the old_competitor_tbl. If not return a value of new to a field called status in the competitor_tbl. Any...
  4. E

    Design

    Ranman256... silly question ... what are the relationships in the 4 tables above.
  5. E

    Design

    Ranman256... silly question ... what are the relationships in the 4 tables above.
  6. E

    Design

    Thanks Ranman256 I will give this a try. I was way off the mark having only a shooters table and a teams table.
  7. E

    Design

    I designed an access db that collects data on our archery match - 200 archers. I have a shooters table to account for the individual scores from 5 different individual events. My reports are filtered to display descending scores for each event. Then I have a report to show combined scores for...
  8. E

    Hello All

    My name is Wayne. Very happy to have found this site as I have so much still to learn. I am a use access frequently so I may need help from time to time to make my databases do exactly what I want them to do or know when the database simply can not do what I need.
Top Bottom