Search results

Hello Everyone, I have a table with following fields. ID, ProfileName, ProfileId, NumberOfEvents, EntityId, RequeueReason, Notes, ReviewedBy, ReviewDate I want to develop a process for quality check. Where I would need following fields. ProfileName, ProfileId,NumberOfEvents, ReviewedBy...

Thank you very much. Your direction was a great help.

Thanks all for your help. I was able to develop what I wanted. For future reference: I created a form with unbound text boxes for time duration format (HH:MM:SS) and added a command button to convert the HH:MM:SS to seconds which will fill up the bound text boxes linked to the table. Function to...

Thank you guys. I was able to create the data entry form as I needed and used SPLIT function for converting as suggested. I was able to prepare a report to show the time as HH:MM:SS. Now I need to create another form for updating the data. I need to show the users the seconds in HH:MM:SS...

Thanks. The time duration is not calculated in this database. We get this report from another source. If the time duration gets stored in this database as long integer it will not be a problem. I only need a form control (text box) to input the data. The users will input as hhh;mm:ss in the...

Thanks for taking a look into my problem. The time duration is not calculated in this database. We get this report from another source. If the time duration gets stored in this database as long integer it will not be a problem. I only need a form control (text box) to input the data. The...

Thanks for the reply. Sorry, can't do that. There is no StartTime or EndTime to calculate elapsed time. I have just hours (for example 500:00:00) worked in a specific date (Dec 20, 2016). I need to input this in a table with a form.

Hello Everyone, I have an Access Application front end with SQL 2014 Enterprise as back end. I would like to add some tables and forms for my teams daily statement. There are 8 teams. Team sizes ranging from 2 to 64. So their daily target hours are different. Table structure will be same for...

Sorry for the late response. Thanks a lot. That did the trick. I was able to do the rest myself.

Hello Everyone, Is there any way to get row total based on criteria in a cross tab query? I am using MS Access 2013. I created a cross tab query. I need seven column with row count based on some criteria. I created 7 queries with the criteria. When I join them all with cross tab query it does...

Hello Everyone, I have 7 tables named with 7 days of week but has same data structure. I can't put them all in a single table because for example in Monday (22/11/16)'s file I have data from Sunday(20/11/16) and Monday (21/11/16), On Tuesday's file I have data from Tuesday (22/11/16) and Monday...

Hi, I started playing with Access 6 months earlier. I learned everything I know about Access from web. I have read many posts of this forum to get started with my project. I have built an application for my team of around 200 members. Thanks to everyone whose posts, blogs and YouTube videos...