Search results

Hi - tblFiles is related to tblStatusLog by the FileNum ... and tblStatusLog is related to the tblStatus by the StatusID. A report would look something like this: Company Files Opened 6 Med Stat 1 2 Med Stat 2 3 Psych Stat 2 1 Files Closed 4...

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...

Hi - I got it ... I did do it in a query Paul - thanks for the direction : for those that also struggle with this in the future, here's what I did. In a query; matching on COMP_ID: Success: IIf(([Value]>=[GoalLower] And [Value]<=[GoalUpper]),1,0) Point: IIf(IIf(([Value]>=[GoalLower] And...

Hi - I did zip it (using WinZip) and it's 23K ... not sure why this isn't working ... but I'll try again. Thanks in advance for your help!

Hi - Thanks, attached is a sample DB ... the system itself is quite large and includes a bunch of other stuff (like Client IDs, etc.) but I won't bore ya with all that. Yes, it is by Comp_ID - the IsScored (yes/no) needs to be checked before adding the point to the employees running total...

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...

That worked ! Thank you !

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...