Thanks. Very helpful. Got it working following your suggestion. Much appreciated.

Hi guys, need help again.. newbie here just learning mysql. I have a timesheet table that have a few columns. ie Date, InvNum, Fieldhrs, UserID, ShopHrs. Everyday employees enter their data into database via web page which works great. My problem is this, trying to write a query that checks if every user has entered data for a certain date.. i've tried the following query, but just returns blank not userid ? SELECT UserID FROM timesheet WHERE "2018-04-23" NOT IN ( SELECT Date FROM timesheet ) Any help would be appreciated if someone could point me in right direction.. ie a real newbie.

I'm using vs2013 ultimate. Don't have crystal reports though. Looking at reportviewer but can only figure out on how to do one payday report. Not sure if possible either way. Was thinking it would be nice if I could some how send all pages to pdf and then print it that way. I'm using Vb as code. And Mysql for database.

Yeah but that is the problem. Using a loop to go thru employees, do I have to bring up a webpage for each one and then hit print 50 + times. Need a way to do it once. Example would be awesome as am fairly new to asp. Thank you in advance.

Help. New to asp.net. I have a webpage with 2 gridview grids that are populated from database. Each grid represents 1 week of a 2 week pay period. The employees are selected from a listbox that is databound from my-aspnet-user database. I can manually select each employee and click on print button and all is good. Printout looks good. My issue is, is there a way to set it up that I can click print once and have all the separate pay info printed for each employee in the list.