Search results

It comes up and shows the code that I wrote. It is not showing anything. Not sure where to put the code. I guess I need clearer directions. I have been doing databases a long time but never this kind of coding.

I tried it in the query and in the reports text box control source and it would not work. Confused...

Not sure what it means.. This is only a guess.. Does it mean that the problem I have will remain? If not, how would I correct it if it's possible?

Would I write the code the same way? Which code builder do I use in Print Event; Macro Builder, Expression Builder or Code Builder? Thanks!!!

It's almost there. It got rid of all but the begining, between and end of the Query/report. Here is what it looks like with the "=" represents the box. =Doc #36: File 1, Page 3 signature and date missing.=Doc #37: File 1, "Office use Only" not filled in.=

When I run the query I am getting blocks in front and after the columns that have no data. "=" represents the blocks.========Could Not Locate=============Record not found========

Yes, that is correct! Thanks..

I am trying to create a query that will remove empty cells in all columns off of another query that collects the data from multiple tables. I like to combine the cells with data in a report. Example: Name Date Column1 Column2 Column3 etc Sally 10/01/10 Text no text text ..... Ted 10/02/10 no...

Finally after 3 weeks of working on this problem it WORKS perfectly! Thanks for all your help!!!! I have another problem but it probably will have to be a SQL script to work. Thanks again!!!

I appreciate your help that you provided but I did mention that I wanted this to work in my report in my first post. Thanks again!

I have attached the database: Here is the flow of order. Form to enter data is: frmRDStudyAudit. On the form the report that the popupform showing the selected dates for the report is Open Report Button. The report pulls data off of the dates provided. Use 10/12/10 and 10/13/10. The...

You have me on the right track and you did figure out what I was trying to do. I didn't think that the query that the information is drawn from would make a difference but it does (Query 1). First, I have a popupform that works off a command button that pops up to enter dates where I want...

I have setup Between dates for records in the date range I want. It would be percentages of all records (10) since I do 10 audits per month that has 22 columns of data that I need to get a percentage of. I'm also thinking that since the data is coming from a date range getting a percentage...

Your assumption is correct. When I use the sum() it does give me the total of all the yeses and N/A's for all the columns. I got it to add in by columns but now I need it to divide into a percentage. The field names are actually document numbers. It is a checklist that I have created and...

I am trying to create a percentage of the (yeses and N/A) / (No's). There are 22 column names from another query. This is what I have tried in my query by I should be in the high 90% range instead of 4%. Yes...

That worked perfectly. Thanks!!!!

I need to add the yeses and N/A's as one in the same column. This is going to a report and there are a lot of columns (around 80), that's why I am trying to combine the two plus they represent the same total since I count them as if they were both yeses.

I am trying to add the Yeses and N/A's in a query from my table. I have tried to count, sum and Sum(Abs and I can not get them to add up correctly. All it is doing is adding the total count in the column. I also need to add the No's separately from the others. Thanks!

I really appreciate the help you have given me. Thanks for all you have taught me. Thanks!!!!!!

Thanks for the help but there is a problem when I try to enter two different dates like 10/12/10 and 10/13/10. The report will come up blank even though that there is data to support those dates.