Search results

I am trying to create a crosstab query that counts the number of events that have been logged for each day of the month. The event date is stored in an ODBC compliant database in date/time format. Unfortunately, the crosstab query counts the number of events for each date/time occurrence. I...

I have a form that I use to collect selection criteria for reports. The controls on the form are combo boxes and date fields. After I run the report, I would like all of the fields on the form to be cleared of the selected values that were used to run the previous report. I have tried the...

Having difficulty with executing the Recordsetclone property of my form. Recordsource for 'frm_event' is based on a table, tbl_events. On the Form's 'OnCurrent' event, I make a call to the function 'DisableEnable([Form])': Public Function DisableEnable(frm As Form) Dim rstClone As...

Greetings: This is a new area for me and I am struggling with how to approach the solution. Have searched the archives but still can't figure it out.... I have a database that stores call center coaching events. I would like to insert a wav file (recorded conversation) into each record and...

I am trying to make a call to an action query (qry_prod_prob_build) in the Group Header of a report that builds/creates a table that is used to graph a chart in the Group Footer section of the report. The action query works fine if I hard code the product name into the parameters collection...

I am stumped on this one and am hoping someone can provide guidance.... I have a report that is based on a crosstab query that summarizes the status of problem management tickets (e.g. open, linked, closed). The report is grouped by PRODUCT_TYPE and for each PRODUCT_TYPE, there are one or more...

There is probably a simple solution to my problem but I just can't seem to figure it out! I have a report that is based on a Crosstab query. The query counts problem management tickets for each business unit location by status (open, updated, closed). In my report, I would like to provide a...

I am developing a series of reports based on data from a problem management system. Each report is based on a crosstab query that groups incidents by a dimension (e.g. analyst, product type, problem type) and tabulates the number of incidents for each member of the group by problem status...

Hello All: Hoping you can help me with a problem I am having with trying to execute a SQL string in my code. I have a table (tbl_rhd_managers) that identifies all managers within a department. I want to write a SQL statement that will return ALL managers within a specified region: strSQL =...

Hi All: I have a main report form that contains 6 subreports. Each subreport is based on a separate query. In some cases, there may be no data available to report for a specific subreport. Each subreport is designed with a 'Report Header' to provide an identifier and a description. For...

Hi All - Looking for help with debugging an SQL string. I am trying to open a recordset using the following declarations and statements: Dim db as Database Dim rs as DAO.Recordset Dim strBU as String Dim strCustomerType as String Dim strSQL as String strSQL = "SELECT BU, CUSTOMER_TYPE...

I have a database that is used to track the closure rates of problem management tickets. My objective is to track metrics (total # of problem tickets by location and customer type, average # of days to close, and 95th percentile). The 95th percentile represents the number of days it took to...

Hi All - looking for some help with a form/subform problem that I am experiencing. I have a main form (frm_local) that has 1 subform (sfrm_local_ims). Each form is based on a different query. I have 'linked' the main form and subform using the 'Link Child Fields' and 'Link Master Fields'...