Search results

  1. C

    Storing multi status dates

    Hi - I've searched for the forum and have read everything on the audit trails, and storing history and have found nothing that quite fits my predicament. Here's what I have: tblFiles FileNum CompanyNum ... tblStatus StatusID StatType: Case, Med, Psych, ProjectRisk Status: different for...
  2. C

    Compare value to upper and lower boundaries

    Hopefully I can explain this well enough - I have - tbl1 Comp_ID Component GoalUpper GoalLower IsScored [y/n] PointValue tbl2 Emp_ID Comp_ID Value What I want to do (in a report) is check to see if the tbl2.Value is between tbl1.GoalUpper and tbl1.GoalLower and if so - do something [either...
  3. C

    Table driven field type display

    Please forgive me if this has been asked and answered and I'm just not searching with the right language. I'm creating a survey ... I have a QuestionTBL with a field called QuestType - that has a value of TEXT or SELECT. On my form I have a cboResponse field that queries a table to get the...
Back
Top Bottom