Recent content by Dona

Problem with Excel 2010. Excel converts cells to a date format. I want it as typed. I tried to format the column to text. This did not work. I typed the following text in each row: August32 April85 Dec90 Aug22 Please help. I do not want Excel to convert the above to a date. Thank you for...

Excel 2007: Lost Format Hi I have 10 worksheets with formatting --- shaded cells, font format of titles, underlining, bold fonts, etc. in a file. Well, they all disappeared!!!!:confused: When I opened the file, I received the following message: Excel found unreadable content in final.xlsx. Do...

Thank you for information.

Thank you very much!

I need some help. I created some tables in Access 2003. I opened the files in Access 2007 and expected to see the date the table was created and modified last. What a surprise! I don't see any the details that Access 2003 had. Can you tell me where to find this information in 2007? Also...

Thank you very much. It worked!

Three fields

Hi, I need help. I want to count all the fields on a record that have a value. I do not want to count the fields with a null value. I want to add up all the NonNull fields on a single record in one column. Any ideas? Thank you.

Hi WayneRyan, I don't think I'm using the module correctly. An error message was returned. I did the following: I created a module and named it QualificationStatus. I typed QualificationStatus: Qualifies([Income], [Dependents]) in the query field. What did I do wrong? Thank you Dona

If would be part of the function. There is no limit.

Thank you. I needed to retype it several times for it to work. I have another question. I forgot to add if 40000 of less 4 For each addition dependent add 2000 How would I write this?? ([Income]<=40000+2000x and [Dependents]=4+X) IIf(([Income]<=25000 and [Dependents]=2) or ([Income]<=32000...

Hi Brian, When I tried to run the query, a dialog box pops up and says: Enter Paramenter "Yes" and another box for "No" Why? Dona

I'm new at this and need help. I want to use the income field and dependent field to determine if a person fits the criteria. Income Dependents 25500 or less 2 32000 or less 3 40000 of less 4 I tried the following: Iif [Income]<=25000 and [Dependents]=2 or [Income]<=32000 and...

Thank you. This worked!!!! I appreciate you taking the time to help me.

Would I write the expression as follows: RoundACT Composite Score: Fix((([Column1]+[Column2]+[Column3]+[Column4])/4),+0.5) ?