Search results

I have two textboxes with dates and need to display months and days in another textbox. StartDateEst = 3/7/2017 DueDateEst = 4/21/2017 =Int(([DueDateEst]-[StartDateEst])/30) & "m " this gives me 1m but how do I know get 1m 15d? In Excel I would use the MOD function, but after searching...

I've built a query with a couple of group by's and a couple of where clauses with a sum field. How do I get the percentage of the total by row in the query output?

Not sure my title spell out exactly what I'm looking to do but I'll try to add some more information. If have a union query between two tables. The first table lists employees and contains a key ID field. Basically, one employee, one record. The second table lists the supervisor for the...

I have a report which is opened through a cmd button with code on the On Click Event Private Sub cmdMentor_Click() Dim MentorSQl As String MentorSQl = "select * from Force_Support_T where [Mentor Name] Is Null and [Centrally Managed Posn Type Desc]='Pal Acq (PAQ) Int Posn'"...

I have a report with a query as the control source. Because of multiple tables the query is producing duplicate names which is fine as one field makes each record unique. On the form in a textbox I have =Count(*) which counts all of the records, but it's counting the duplicate names as one...