Search results

Did you check the format of the textbox? I have a report with 70 or so sums, counts and percentages in the footer. I think access might limit you to 255 controls. I'm really unsure about that. Anyone else know? Brian.

Thanks Jon, Works Great! Brian.

I have a table that has two fields named [Ave1] and [Ave2]. I have a query based upon that table and I want to show only the records where [Ave2] is greater than [Ave1] by 30 seconds but not 31 seconds. For example: Like; Ave1 Ave2 00:00:10 00:00:40 00:01:02 00:01:32 Not...

Thank for the reply Pat. The previous post worked out best. I simply copied the control several times and modified its source control. I wanted a span of about an 8 hour period and it wasnt that difficult to copy, paste and modify. Thanks anyway.

SUCCESS!! Thank you very much! For those of you interested, the following is what finally worked. =Count(IIF([OutageTime] Between #10:00:00 AM" And #10:59:59 AM",0))

cant help with your first question but i'll try the second one. try this code behind a commandbutton on your form. Private Sub CommandButton1_Click() ToSave = Date Docmd.OutputTo acReport, "YourReportName", "MicrosoftEcel(*.xls)", "C:\Windows\Desktop\" & ToSave &".xls ToSave will equal the...

I know someone out there knows the answer to this.

Rich, I tried what your suggested and I finally got a result. Bad thing is that it counted every record instead of those that are between 10 and 11. A physical count would reveal there are only 15 but the count returned 1457. Any thoughts?

In the report footer in and unbound textbox type the following: =Sum([TotalLoans])

Thanks Rob, but I tried this earlier and it does'nt work. Any other thoughts?

Does anyone know how to get this to work? In a control on a report I want to count the number of records between 10:00:00 and 11:00:00. The field name is [OutageTime]. I do not want to do this in the grouping and sorting because I intend to copy it and use it for every hour. In the past I...