Search results

Hi All, I am having trouble with formatting a field in Access. The field is called COMPLETEDATE. The data in this field has the format of "1110314" the data is of type string. How do I drop off the leading 1 in the string? :confused: What I would like to see is "110314" not "1110314" Can...

Hi, I am using VB 2008 Express to connect to an Access 2007 database. I have a combo box called SelectYearMonth that is populated by the database. When I used the Access report VBA, I used the AfterUpdate() event to calculate a sum. I need to know how to do the same operation in VB 2008...

Hi All, I am having trouble with a report calculation. My report is grouped by YEARMONTH and then by JOBTYPE. YEARMONTH is numeric and JOBTYPE is text. Details are hidden as they number in the hundreds. I have a query that is to run after the user chooses a date from a combo box. The combo...