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

Thanks for your help - in this case it must be mode I am looking to use. I've attached a sample table. In this scenario I would only want records with a "1/4/2016" value in the date field. 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...

Does anyone know how this would work? Thanks!

I need to quickly separate the data each week by those parameters. And then, export that report into an excel file. It would be nice if it was automated, and the system automatically could export each of the 8 excel files.

Hi, I have uploaded sample data. So, there should be a separate output for: Biweek 26 – 1/1/2016 Biweek 26 – 1/15/2016 Weekly – 1/1/2016 Weekly – 1/8/2016 Weekly – 1/15/2016 Weekly – 1/22/2016 ect. Thanks for all your help

Thanks! I have a query that separates the pay frequencies. But how would access separate by the distinct pay dates in each frequency?

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