Recent content by SDickson2

Wow i see my error in the writing the IIf expression works Thank You soo much!!

i seem to be writing this wrong TobaccoProducts Value was converted to numbers from a "how often" questionaire thus (CInt([Q1 TobaccoproductsCigarettesChewingTobaccoCigars])+CInt([Q2 TobaccoproductsCigarettesChewingTobaccoCigars])+CInt([Q3...

Ok thank you will try repeating formula

writing as suggested I get error message "Undefined function <name> in expression SevereTobaccoAddiction: IIf([Assistv30]![TobaccoProducts] >=24,1, 0) TobaccoProducts is actually CInt(Q1)+CInt(Q2)+CInt(Q3)+CInt(Q4)+CInt(Q5)+CInt(Q6)+CInt(Q7) in same query, which works giving me scores ranging...

I have a query that sums values from tables and want to set condition something like this >=24 is 1 <24 is 0 and tried to write expression like this Severe Addiction: IFF "expr"[Assistv30]![TobaccoProducts] >=24,"1", "0" but cant seem to figure out what to use as the underlined EXPR

not sure how to write expression statement that allow a person to continue answering subsequent questions if answers with YES and how to stop the progress of form when a NO answer is given

End Result for Physical Profile Client(AutoNumbering) Physical = 60(total) subtotal is multiplied by Constant = total Constant = 10 subtotal = 6 subtotal = (question 8) + (question 9) + (question 10) + (question 11) + (question 12) (question 8) = 2 (question 9) = 0 (question 10) = 2...

I am trying to get results Col1 (2) Col2 (0) col3 (2) col4 (0) col5 (2) col6 (0) to equal total score of 6, and not look like 202020 your help is very much appreciated

also when in Query my statement ([HealthProfile]![Walkingupaflightofstairs]+[HealthProfile]![Runingthelengthofafootballfield]+[HealthProfile]![Sleeping]+[HealthProfile]![Hurting or aching in any part of your body]+[HealthProfile]![Gettingtiredeasily]) AS TotalPhysical FROM HealthProfile; Is...

I was thinking is best to make each profile a separate table then each table (10 of them) would be carried over to a Table(or Query) called the DUKE where another calculation is needed on an individual ClientID's subtotal per profile in effect, the Table called the DUKE would show each ClientID...

confused where i put code? from Query table i have created, the properties is: SELECT HealthProfile.ClientID, HealthProfile.Walkingupaflightofstairs, HealthProfile.Runingthelengthofafootballfield, HealthProfile.Sleeping, HealthProfile.[Hurting or aching in any part of your body]...

I have a table created that has numeric values related to a questionaire that has multiple choice answers that will give a score. Each questionaire is from a different client. I am trying to get values for 10 different Health Profiles (example: Physical,Mental,Social) Physical will only take...

Hi everyone I am very new to Access world and Databases but am extremely excited in Learning