Search results

Thanks! That worked perfectly!!!

This is the code in a text box I am trying in the report but keeps giving me an error: =Count(IIf([Total] And [dateofaudit]="2011",0)) It is in the report footer while the Total and dateofaudit is in the detal section.

The name of the query colums are Total and dateofaudit that I am using for this problem. I enter the number of findings I find in the total column and enter the date of the audit. I want to show how many findings I have for the entire year, either being 2010, 2011 etc. I hope this makes it...

I have a graph that is pulling data from a query. What I am trying to do is add a total for the year. I have two columns, one is, Dateofaudit and Total which shows the total number of findings for a particular finding that I enter myself. I tried using the sum and Total functions but can't get...

Ok. I didn't understand what you menat by "dirty" but I do now. I appreciate both of your help! Thanks!!

What I have noticed in Test2 Query, the results come out like this: ** Doc #30-5: Could Not Locate ** Doc #37: "Office Use Only" not filled in Doc # 37: "Office Use Only" not filled in. Etc... Memo: Duplicate in sectionDoc #37: "Office Use Only" not filled in The first line shows ** at the...

It would need to a form that will look like this by date as the row source: Date-----01/10/10-----05/10/10-----10/23/10 Doc 2-----Yes------------No-----------N/A ComDoc2 missing sig---Not dated----------- Doc3------No------------Yes-----------Yes ComDoc3--Can't locate----sig missing-------...

I consider this a learning experience so sometimes you don't always get what you want out of Access. It does alot but it does have it's limitations. I wonder if I normalize the DB if I can come up with something similar to what I would like to have. The main thing is to be able to see it as...

Yes and N/A are as one. Meaning that Yes the document is there but can having a finding because is missing on the doc giving it a write-up. N/A simply means that the doc is not required or is a one-time doc. "No" means the doc is missing so it is stated as "Could not be located". Now that I...

So if I understand this correctly, Findingdescription is where I can have the column in names in a row instead which would amount to about 160 rows for the Doc's and Com-Doc's. I understand the rest.... The YES and N/A are as one and No is by it's self. I could also use these as a drop down...

I think I understand what you are proposing but with all the tables I have I don't think I can since I only can have so many columns per table, it maybe impossible for me to do. The doc#'s are yes, N/A or No and the Com-Doc's (com means comment) are the findings for each of the doc#'s I think...

How can you set up a table to show things in rows versus columns? I never seen that before. It's always in columns that I knew of.. I also tried to insert a sub-report with the can grow and can shrink to yes and since I have many colums/rows there would be a large separation between each...

Yes some of my fields may contain semi-colons only when there are multiple findings for that document. The individual being inspected will have all findings for each document (if any) in the findings field (in the query or report) from multiple fields on one line, if possible. Usually there...

There is only a semi-colon if there is more than one finding for that field or it is just a period at the end of the text (finding). Example: could not locate; need document.

So another words there is no way to make this work the way I would like it to? We were so close except for the boxes between the fields. If it could be replaced with the semi-colon (;) then it would be perfect.

I'm not sure what you mean by properly aligned. Can you explain? Thanks!

The number of fileds can't be helped but I can remove the # and - symbols if needed. If they are removed can it be done then? I know it's a lot to ask but this will save me so much time. I have cut my work load by more than half with Access as I have done in every position I've held but this...

Has anyone been able to figure this problem for me? I appreciate your help you have all provided to me. Thanks!

I have attached the database. Note the queries and the Report are named Test(). If possible I like each finding separated by a ; and a space if possible Example: Finding1; Finding2; Finding3......etc. Thanks for your help!

First I'm trying to do this in the query. Here is the code I wrote: Findings: [Com-Doc #2] + “ “& [Com-Doc #12-5] +” “& [Com-Doc #25] This is the error I am getting: "The expression you entered contains invalid syntax" When I put the same code in the countrol source in the Report with the...