Search results for query: *

The solutions worked out just fine. Thank you all for your help. Greatly apprecited!!!

Hi Laurie and thanks for your reply. I believe that my problem is with the syntax I am using for the Text Box Control Source. This is what I have: =Count("[Uses_Food_Pantry] = 0"). I know that isn't correct, but am not sure what to try next. This is one of those things that I have not had to...

I am attempting to add a total on my report footer line containing a count that reports whether a check box on each detail line generated by the report has in fact been checked. I am trying to use the COUNT function in my Control Source, but am somewhat confused as to the syntax required to...

Thanks all for your help!!! Problem solved.

Thanks Andy for your time. Much appreciated!

I am trying to open a specific .PDF file from an Access (2010) command button. Can anyone help with this? Any help would be greatly appreciated.

Thank you Ken. That worked perfectly.

What I would like to do is the following: During the report exection I would like to change the font weight of a given report item, based on the value of another report item. This would be done on a line by line basis. Example: FIELD1 FIELD2 FIELD3 12345 ABCD (bold)...

Thank you everyone for your help. For the moment, the solution to adding these numbers in an Access report has eluded me, however, I was able to get the results I needed in Excel. An agreeable work around for the moment. Thanks again.

My problem is that all I have to work with is the data in the column as is. Is there a way to convert the "1.30" to hhmm?

My last question for today. Everybody here is so helpful. I need to sum a column of times on a report and display a grand total on the report footer. Sum hasn't worked for me so far. The times print as follows on the report: 1:00 0:30 0:15 1:30 I need to total these. As always, any help...

Your reference to date/time tipped me off. I was using date and time as two seperate fields. I see where I was going wrong. Thank you for the tip. Much appreciated.

I am trying to determine elapsed time using the function listed below. It works fine until the time crosses over into another day. I am trying to execute this function from an Access Query. I need to pass the starting date and time and the ending date and time, however I am having a problem...

Mark, That worked just fine. Thank you.

Thank you Mark. I will check those out.

What I would like to do is display a final report total in a text box, but not one that would simply use the SUM, or COUNT functions. I have a series of line items in a report, and on each detail line is a CHECK BOX. I would like a total at the end of the report that reflected a count of only...

I am using a simple formula to keep a running total in a column. Presently, the data is displaced as follows: $150,000.00 $123,000.00 $121,000.00 $121,000.00 $121,000.00 $121,000.00 I would like to hide the duplicate values in this column. In other words, eliminate the last three references...

Is there any way to surpress the printing of blank lines in an Access report? Any help would be very appreciated. Thanks.

Hi Leslie, That worked like a charm, and you are a gem. Thanks so much. Jeff

I am trying to total a check box table column for all rows that are in fact checked. I am using the query wizard in this way: Field: Column Name Table: Table Name Total: Sum Sort: Show: Criteria: True I am getting the correct numeric result, however the result is apprearing as a negative...