Search results

I have this code in a module that keeps timeing out after 60 seconds is there a way to make it run for at least 10 minutes. Dim db As Database Dim strSQL As String Set db = CurrentDb strSQL = "INSERT INTO Daily_Trends_All SELECT Master.* FROM Master WHERE...

I have a table with salesdate[date], center[text], sales_rep[number], and sales[yes/no]. I need to find the number of sales_rep in each center by month who had yes sales Is there a way to make query that would group by month and center, and give a unique count of the sales_rep where sales is...

I have a form that I use to make csv file using vba code. Is there a way for me to zip the csv file using vba code or anyother way in the form. Thank you Nileshtx

I there a way to exporl an results of an sql into excel spreadsheet and let the user pick the file name and location?

I need to create a form that shows data from a table in data sheettype of format. My problem is i need to find a way to let the user of the form pick which fields to group by, how many fields form the table to group with, and what order the fields should be grouped by.