Search results for query: *

Hmm..Here is my Report. The record source is a query. There is a Group by CallerID section and a calc total next to it by sum of calls(which is calulated from the query by counting sub category). The detail section goes like this: (Fields from query Record source) - Category, Sub Category and...

Is there a way to sort by a Calculated Field in the Group by Header. When I try this, it keeps telling me you can not sort on aggregate fields? What can I do?

Hi, I just upgraded from excel 2000 to 2007 at work. Many of my macros display this when I run them - "not enough resources to display completely" All macros worked fine before upgrade. Example of a macro experiencing problems: Sub one_page() Workbooks.Open Filename:= _...

Sorry, I'm a novice. So your saying I should do this in perhaps the optwho control's after update.

I need a field to say Bank 1 if opt 1 is selected or bank 2 if opt 2 is selected. I can not seem to get this to work. Private Sub txtwho2_BeforeUpdate(Cancel As Integer) If optwho = 1 Then txtwho2 = "Bank 1" Else: txtwho2 = "Cardella" End If End Sub Thanks for any help

Thanks it did! Put in iif statement in the update query.

I have a problem that I having trouble resolving. I need field 1 to be updated based on multiple criterias. If field 2 is null set field 1 to off if field 1 = a hyphen '-' And if field 2 is not null set field 1 = to the value of field 2 that is not null. Is this possible? Thanks, Joe

What I'm looking to do is if the date from the first column is greater than today's date make cell null otherwise fill in the cell with appropriate data. Thanks

I need a formula to first look at a cell in column A and to decide if it is greater than today's date to place a null value in the cell right off the bat other wise continue on with the formula. Example which does not work...

How do you schedule an autoscript to print to specific printer? Thanks!

Thanks PHV I ended up using this : Format([SumOfScheduled]\(60*60),"00") & ":" & Format(([SumOfScheduled]\60) Mod 60,"00") & ":" & Format([SumOfScheduled] Mod 60,"00")

Thanks for the reply. I'm still having problems. I used what you provided "int([SumOfScheduled]*24)&":"&format([SumOfScheduled],"mm:ss")" and get the following for ex. on 134400 secs 3225600:00:00

PHV, That worked too. It just needed another ( after format. Thanks!

Hi, I'm unable to report time over 24 hours such as 37:20:00. This is an reference to a field that is in seconds. I tried this function ss: 24*Int([SumOfScheduled])+Format(([SumOfScheduled]),"hh") & Format(([SumOfScheduled]),":nn:ss") and it did not work. For ex. I had 134400 in secs and the...

Perfect! I can't believe I did not think of that. Joe

Thanks, I tried that but it returns all values with a negative. I looking for a return of a negative or pos based on the field I'm formatting. (There's a mixture of neg and pos time values) Joe

Try this thread: http://www.tek-tips.com/viewthread.cfm?qid=913587

Hello: Does anyone know how to display -120 seconds to -hh:nn:ss format? I used NStart: Format([SUMOFSTART]/3600/24,"h:nn:ss") and this only reports a positive time value (00:02:00). How do I get the - sign in front? Any tricks that anyone knows? Thanks, Joe

Thanks, The custom filter does not work right for what I need. This is for a user who's just strictly using the autofilters. I was wondering if there was a formula sort of an If statement to not allow visible zeros within the subtotal. Thanks, Joe

Is there a way to have a subtotal formula not include zero or null values? I'm using this basic subtotal formula that is connected to a auto-filter list. SUBTOTAL(1,C5:C366) Thanks for any help. Joe