Search results

Hi, I have one [Master Query] with employee ids, pay frequencies (biweekly 1, biweekly 2) and paycheck issue dates. I also have a second query [Biweekly1 PayDates] that gives me the biweekly 1 paycheck issue dates. Essentially that query returns two paycheck issue dates for me. I want to...

Hi, I have two queries, [Exception Report Employees with Different Frequencies] and [Biweekly]. If employees populate on the Exceptions Report, I want them to be deleted from the Biweekly query. We could use the field “Empl ID” to find matches. Is there an easy way to do this? Thanks

Hi – is there a way I can have a query only give me the average number from that field? In other words, I have a date field and I want the query to only return records with the average value in that field. Let’s say “2/4//2016” is the average or most common date, can a query only return records...

Hi, Every week a file will be imported into a table which breaks out into three separate queries, depending on the pay frequency. Within that, I know one of the pay frequencies will have two calendar dates associated, another will have two dates, and a third will have four dates. These dates...

I have a custom web app on SharePoint. It is based off a table I have on my desktop, which also has a form I created associated with it. Is there anyway to get that Form publish to my app, so users can enter data with it? I was hoping a simple copy and paste would work into a blank view, but it...