User Profile
DataComplianceNerd
Copper Contributor
Joined Jan 09, 2020
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.Re: 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.....Re: 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])Excel 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.
