User Profile
DataComplianceNerd
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Microsoft Form Fill in using Token Data
I have created a form using Microsoft Forms and question 1 is an Identification Number for the respondent. I am sending the respondent to my form from a URL in my data system. My data system allows me to add a token to my form URL containing the Identification Number. Is it possible to complete a form question using Token data in a URL. If so, can anyone provide advice on the best way to complete this? I appreciate any advice possible.1.6KViews0likes1CommentPower Query and BI
Created an Excel file of data to share with other departments using Power Query and BI added some interactive pieces to it. Users are getting errors when trying to open it. Do they have to have BI loaded on their machines to use this or is there a way around it? Thanks,829Views0likes3CommentsRe: Finding Multiple Values
I apologize for sending this in the wrong direction,George_Hepworth. Here is some actual data from my payroll table that I am working with. I would need employee 10567 to show up in my list because he has functions 215 & 221. I would not want 22301 to show up because they are only function 125 all the time. Does this make more sense of what I need? Record Number ID Pay Run Pay Date Pay Code Pay Code Description Amount ASN Account # FCode Building Dept Object Code Grant # Percent Distributed 70 10567 299 20-Sep-19 1 $841.77 128 215 7 490 1280 0 1 71 10567 291 26-Jul-19 424 $382.00 199 221 66 0 1990 1618 72 10567 291 26-Jul-19 424 $418.00 199 221 66 0 1990 1609 73 22301 299 20-Sep-19 1 $942.27 163 125 8 0 1630 1009 74 22301 297 06-Sep-19 1 $942.27 163 125 8 0 1630 1009 75 62310 299 20-Sep-19 1 $225.38 124 513 13 0 1240 0 1 76 62310 299 20-Sep-19 1 $225.38 124 513 13 0 1240 0 1 77 62310 297 06-Sep-19 1 $225.38 124 513 13 0 1240 0 1 78 62310 297 06-Sep-19 1 $225.38 124 513 13 0 1240 0 1 79 62310 297 06-Sep-19 200 $182.98 194 221 13 0 1940 1519 80 62310 291 26-Jul-19 424 $382.00 199 221 66 0 1990 1618 81 62310 291 26-Jul-19 424 $418.00 199 221 66 0 1990 1609 82 62310 289 12-Jul-19 236 $392.10 192 221 66 0 1920 1609 83 73001 299 20-Sep-19 1 $225.38 124 513 74 0 1240 0 1 84 73001 299 20-Sep-19 1 $225.38 124 513 74 0 1240 0 1 85 73001 299 20-Sep-19 1 $225.38 124 513 74 0 1240 0 1 86 73001 297 06-Sep-19 1 $225.38 124 513 74 0 1240 0 1 87 73001 297 06-Sep-19 1 $225.38 124 513 74 0 1240 0 1 88 73001 297 06-Sep-19 1 $225.38 124 513 74 0 1240 0 1 89 73001 291 26-Jul-19 424 $382.00 199 221 66 0 1990 1618 90 73001 291 26-Jul-19 424 $418.00 199 221 66 0 1990 16092.1KViews0likes4CommentsRe: Finding Multiple Values
Sorry for the confusion. I don't necessarily care about the pay codes, just the functions. When I run the report I need anyone with more than one function anywhere within the specified date range. So if I select July 1 - August 30, I need a list of people to be created that have more than one function code.2.2KViews0likes6CommentsRe: Finding Multiple Values
George_Hepworth Here is the setup for my Payroll Table: I load an Excel file I get from my accounting department each week. the highlighted fields are lookups to other tables in my database. ID is linked to my Employee file where ID is my primary key and one line per employee. My payroll table has thousands of lines in it and just keeps growing each week when I get a new file. My ultimate goal is to create a report of those that have more than one Function Code for a range of pay dates. An employee may have multiple Pay Codes, but under the same function. I need the ones that have multiple functions as well. Does this make sense? I have been racking my brain on how to make this work and just can't get it.....2.2KViews0likes8CommentsRe: Finding Multiple Values
Thanks, I missed one. I saw your other post about ID being the primary key, and it is not. My ID field is their employee number as my identifier. Each line in my payroll table has an identifying record number that is auto sequenced. Each employee could have anywhere from 2-6 lines per pay period depending on their function. I just need to figure out a way to determine those that are doing multiple functions.2.2KViews0likes10CommentsRe: Finding Multiple Values
George_Hepworthhere is what I am using: Query 1: SELECT Payroll.ID, Payroll.[Pay Run], Payroll.FCode FROM Payroll GROUP BY Payroll.ID, Payroll.[Pay Run], Payroll.FCode; Query 2: SELECT DistinctJobFunctions.ID, DistinctJobFunctions.[Pay Run], DistinctJobFunctions.FCode FROM DistinctJobFunctions; GROUP BY DistinctJobFunctions.Pay_Run, DistinctJobFunctions.ID HAVING (((Count(DistinctJobFunctions.FCode))>1)); I get the error when running the second query and after I close the error, it highlights the word HAVING. Thanks for all your help.2.2KViews0likes12CommentsRe: Finding Multiple Values
Thank you for your help, @George Hepworth. I followed your instructions and everything is working as expected, except when I try to run the second query. I am getting an error message of: The LEVEL clause includes a work or argument that is misspelled or missing." It doesn't like the HAVING as it appears on a list of reserved words for Access.2.2KViews0likes14CommentsFinding Multiple Values
I have a table that has thousands of rows in it. I need to write a query to pull out lines where a person is serving more than one function. Below in my example I want Micky below to appear in my query because he has multiple functions. Minnie would not appear because she has the same function the whole time. Example: ID First Last Date Amount Function 12833 Micky Mouse 07/26/19 1,219 226 12833 Micky Mouse 07/12/19 1,219 227 12833 Micky Mouse 09/20/19 1,219 228 56025 Minnie Mouse 08/23/19 1,219 226 56025 Minnie Mouse 09/06/19 1,219 226 56025 Minnie Mouse 08/09/19 1,219 226Solved2.3KViews0likes16CommentsRe: Calculated Fields with iif statements
Good Morning, I am having a similar problem. I am trying to use a calculated field to determine an amount expended from a budget. However, one of my accounts has over spent and therefore a negative number. I am getting this error for that account: #Div/0! I am using the following formula that is working for all my accounts except the one over spent. How can I update this formula to work with negative numbers: IIf([BALANCE]=0,0,([BUDGET]-[BALANCE])/[BUDGET])9.9KViews0likes0CommentsExcel Formula Assistance
I am receiving an excel file with thousands of rows of data in it like this: I need to end up with an Excel file that has one line per employee for each individual pay code or function. Steven Williams above would have two lines in my file as he has two different pay codes but all his function codes match. Sheldon Cooper would have only one line in my file Penny would have two lines Doylene would have two lines. I need to have the data in Excel format when I am done for a merge project that occurs next. Any help is greatly appreciated.855Views0likes2Comments
Recent Blog Articles
No content to show