Search results

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) ?

If I use your suggestion, what happens if the result is 18.3? This should be rounded to 18 .....not 18.3 + .5=18.8 rounded to 19.

Please help me with the round function. I want .5 to round to 1. Here is an example of my data: (18+18+18+20)/4 = 18.5 rounds to 18. I want it to round to 19. I used the following expression: RoundACT Composite Score: Round((([Column1]+[Column2]+[Column3]+[Column4])/4),0) Thank you.

Please help. The sum statements work; however, when I add the GPA statements, this does not work. Any suggestions. I will need averages for other fields. What am I doing wrong??:confused: SELECT Term, Sum(CASE when apc Not Like "YN" then 1 else 0 end) AS Applicants, avg(CASE when GPA = apc Not...

You can also do the following in design view: right click on the field (your expression) select properties type in fixed for format type in 0 for decimal places save your query Hope this works for you!

Hi, you might want to check out this document http://www.marshall.usc.edu/computing/PDF_Files/Access/AccessXP-Adv_Queries.pdf Check out page 16. Good luck!