Recent content by jeffreybrown

Thank you for the direction. I'll give this a try.

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...

Thank you for the direction. Much appreciated.

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?

Thank you very much, all is sorted out now. :)

Ok that is what I was thinking is the next step...build a second query off of the LastSupervisor query. Thanks so much for the direction. I'll try it now.

Hi plog and thanks for the reply, All works well with this query setup; however, it only works if I don't add any other information from the 2nd table other than the SupervisorID. As soon as I add the Supervisor name it adds back all records instead of just the Last SupervisorID.

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...

Works like a champ. Thanks again.

Hi Paul, I just noticed using the cmd buttons the report open opens fine using the OpenArgs argument of OpenReport; however, if the user tries to run the report simply by double clicking the report in the Navigation Pane then a Run-time error '94': Invalid use of Null is raised. On clicking...

Thank you Paul. This worked very nice.

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'"...

Perfect. Thank you so much Paul. I'm a little dense but finally figured out what you were saying. So many cool things to do in Access.

Hi Paul and thanks for the direction. I'm a little lost on the Group header part. I see in the report Report header and Page header, but how do I get the Group header?

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...