User Profile
Collapse
-
Concatenating email addresses from a report into a single string
I have a report that lists the employees who's recognition has been approved and an email needs to be sent to their managers. The report is grouped by those managers. There is a text box that shows the manager's email address, and then one or more employees will be listed underneath each manager. I'm attaching the report to the email so I do not need anything beyond just the manager's email addresses. I need to combine all the manager's email... -
I had two departments selected with check boxes and this is the filter string "strFilter" = (DeptName = "RFP") Or (DeptName = "Engineerin g")
And I think I may have mispoke. It's not a calculated field as such, it's a count of records, but it is happening in the query which is a combination of two queries. The first is a list of all employees being pulled from a master HR database. The second is a count... -
-
...Code:Private Sub cmdOpenReport_Click() Dim strFilter As String Dim lngLen As Long 'Identify which departments are selected for the filter string If Me.chkCFAA = -1 Then strFilter = strFilter & "(DeptName = """ & "CFAA" & """) Or " End If If Me.chkCFMP = -1 Then strFilter = strFilterLeave a comment:
-
jpreator started a topic When I open a report using vba and apply a filter I lose the ability to sort.in AccessWhen I open a report using vba and apply a filter I lose the ability to sort.
I have a report that has three components: department, shift, and a calculated field. I am grouping by department and shift and sorting the calculated field in descending order. When I just open the report it works great. When I use a form with checkboxes that allows the user to choose which departments to include in the report it stops sorting by the calculated field. It will not even let me manually sort by that field. What have I messed u... -
Access 2013 query duplicating records
I need to combine that data from 2 seperate queries. Each query is counting, one the number of employees in a department by shift and the other is counting the number of employees that have entered a help idea into the system. The problem I'm experiencing is that when I pull the data from one or both of the queries it is duplicating the records. When I run either of the queries that I'm pulling from they have no duplicates. Here is the sql from... -
Thank you both for your replies, that seems to have done the trick.Leave a comment:
-
If I understood what you were asking here is an example of how the report turns out. It leaves blanks and so I cannot get the turns calculation to calculate.
Code:[Value Stream] [DeptName] [Rej][Comp]/[Sub]=[Turns] [Centerfire ] [ CFAA ] [ ][ 1 ]/[ 2 ]=[ 0.5 ] [ ] [ CFMP ] [ 3 ][ 14 ]/[ 3 ]=[ 4.7 ] [ ] [ Plating] [ ][ 1 ]/[ ]=[ ]
Leave a comment:
-
Access 2013 query has blanks when I need to display a zero
I have a query that is counting the number of records that fall between two dates as specified in a form using two combo boxes. The query is grouped by two categories, value stream and department. I need to return a count for each department. It works great if there is a record, but I need to show zero if there are no records. I'm combining this with two other similar queries to make a report which uses the values to calculate another value so...Last edited by Rabbit; Nov 2 '15, 05:42 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display
Show More
Leave a comment: