Search results

Yep, I just wanted to see if there was another way of doing it without bringing Variance into the mix.

Variance is Decimal. It sorts properly without applying the format function but doesn't after. I don't get it either

When I sort it doesn't distinguish between positive and negative values. So -07:00 will appear before 08:00.

Was putting the Abs() in the wrong spot. Does what it's supposed to now. But I also want to be able to sort this value from high to low, which I guess is a whole other thing. Sorting this way just treats all values as positive.

Mark, 9 is the absolute of 09 Doc, I can't get that to work at all, doesn't like "Double" I get an expression error as soon as I put it in

Thought we had but that turns values like 5:09 into 5:9 Still looking

Hi, I'm converting minutes to display as HH:MM but have an issue when the number is negative. Anyone know how to write this so I don't end up with a negative in front of the minutes? Format([Variance]\60,"00") & ":" & Format(([Variance] Mod 60),"00") i.e. -193 gives me -03:-13...

Thanks smig does what I'm looking for,

I was afraid of that, I'll try the example route My table looks likes like this, where ID is my primary key and an auto-complete field ID Interview Date Person 1 1/12/2015 Tom 2 1/12/2015 Carol 3 1/15/2015...

Hello, I just started using Dlookup but seemed to have hit a snag and not sure how to fix it. I have a form with a text box for the date and a subform datasheet. The subform shows data that corresponds to the date in the text box. I wanted the textbox to show the next date that was greater...

Well I discovered subqueries and seem to have it working with this: SELECT Sum(Interview_Schedule.Completed)*-1 AS Completed, Count(Interview_Schedule.Completed) AS SignedUp, X.Interview_Schedule.Interviewer_A FROM (SELECT Interview_Schedule.ID, Interview_Schedule.Completed...

And therein lies my probelm. How do I apply a count in a union query? I'm not an SQL person and normally just build my queries in design mode but Unions don't have that luxury.

While I appreciate all that and already have various versions of it working, I'm still curious if anyone knows of a solution to my initial question, how to sum the count of 2 fields from seperate queries?

That would be too easy! haha. I only did it this way because I'm modelling the form on an old excel sheet that was being used before and wanted to keep the layout the same (People hate change). I wanted to see if it's possible to keep it the same way and still accomplish what I need. But yes...

I have a sign up form where people select their name for the time slot they want, there are 2 spots open per time slot, so I have Interviewer A and Interviewer B. Records can then either just be a name in A or a name in A and B. I would like to run a report that shows how many times all the...

Well I figured it.....looks like all I needed to do was change the dots to exclamation points. Was thinking to hard! Me!cboProject = Null Me!cboProject.Requery Me!cboProject = Me!cboProject.ItemData(0)

Hi, looking for some help on this. I have a navigation form [Main] with a subform [NavigationSubform]. The subform has 2 combo boxes [cboAgent] [cboProject]. Ultimately, I would like my selection in cboAgent to requery cboProject after update. I have done this before outside a navigation...

That's perfect! Thanks And yes, I just changed the Date field, I inherited this table and hadn't noticed yet.

Hi CJ, SELECT [Daily_Agent_Calls Original].Agent_Name, Sum([Daily_Agent_Calls Original].[Calls Answered]) AS [SumOfCalls Answered], Sum([Daily_Agent_Calls Original].Total_Talk_Time_min) AS SumOfTotal_Talk_Time_min, [Daily_Agent_Calls Original].Date FROM [Daily_Agent_Calls Original] GROUP BY...

Hello, I'm looking for some guidance on this one. I have a table, tblDailyCalls, that contains agent_name, date, calls_ answered, and talk_time. Ideally on a form, the user will select an agent, enter the date range in txtStartDate and txtEndDate and a report opens to show what the total...