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

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

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.

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

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

I want to convert my dates to months so I added the statement below in the Field section of my query. It is not working. What am doing wrong...

What's the best way to setup this db? I have the following information: Company Company ID Program A Program B Program C Program D 2000 2001 2002 2003 2004 2005 The years indicate the year the Program participated in the company. For example, Program A participated in Company Z from 2000 to...

I've attached a sample of what I'm trying to do. I want to count the number of hits in the column (each number represents only one hit). For example, Bill had a total of 2 hits. Please help me count the hits. Thank you.

I want to divide d8/b8; however in some cases d8 might be 0 or b8 might be 0. If either d8 and b8 = 0, I want a dash. Found solution: =IF(ISERROR(d8/b8),"-",d8/b8)

How do you query date/time? I have a field with date and time, e.g. 4/2/2004 5:12:33 PM. I want to query all records before 4/2/2004. When I type < 4/2/2004*, I get an error message. Any suggestions? Thank you.

I want to query the Top 100 scores; however, I want the ties, too. For example, number 100 has a score of 7490. I want to include the additional 5 records with a 7490 score. This would make the query return 105 records. Is there a way to do this without using "Select Top 100 with ties"? How...

I need help. I used the code below. It works; however, if one group report has only one page. It currently says page 1 of (blank) when I use the code below. I want it to say page 1 of 1. WayneRyan answered my Report post. He suggested adding the following line: Me!ctlgrpPages = " Page " &...

I used the following code. It works; however, one group report has only one page. I want it to say page 1 of 1. I don't know how to write the code and where to put it. It currently says page 1 of .Please help. Thank you. Dim GrpArrayPage(), GrpArrayPages() Dim GrpNameCurrent As Variant...

I need help. I created a pie chart in a subreport. The chart is linked to a code. I want to exclude one field out of a record. Each store may have a different inventory. The pie chart may have 45 potatoes, 20 tomatoes, 30 lettuce and 0 green beans. I want to exclude the green beans from...

I need help. I created a pie chart in a subreport. The chart is linked to a code. Every page is different which is what I want. However, I do not want the pie chart to show a 0% when the no response field (or any other field) is zero. After all who wants a pie chart with a 0% as one of the...

I need help. I created a pie chart in a subreport. The chart is linked to a code. Every page is different which is what I want. However, I do not want the pie chart to show a 0% when the no response field (or any other field) is zero. Please help!