Recent content by zsalem

Hi All. I have a query where I am retrieving about 50K records with a field title ppe_date among many others like Name, Account Etc. This query retrieves 13 weeks of data, so at match there are 13 separate dates in the ppe_date field. I have a static Table That has two columns, Wk# Column...

My output table needs to show... Multiple employees, the types of pay they received each week ending date, and the number of visits they did that week. If I link up with Empl ID number it will repeat the visits because there is duplicate employee numbers due to multiple weeks. I understand...

All Below is what I am trying to do. I need to update a table (Table A) with data from another table (Table B) but only update the first row or 1 row of each grouping of rows. Table A IDNmbr Empl_Numb PEREND Names PayType Visits 1 10047 9/16/2016 JohnDoe REGULAR 2...