Search results for query: *

Hello-- I need to start getting data from Google Analytics. The tool is equipped to 1)export data in CSV format as well as 2)email the csv file. However, the format is not useable. The data I want is there, but underneath a few rows of junk (titles, etc.). I know it is possible to pick...

Hi There-- I am wondering how you would assign ranks to records based on their values--i.e. the record with the highest value gets 1, the record with the second highest value gets 2, etc. Ultimately I need a query that will have 5 original fields and 5 calculated fields which contain rankings...

Hello- I am wondering if there is an easy way to build a formula field in one subreport which uses fields from two other subreports. Thanks for the help!

Hello-- I am building a very simple report which pulls a couple of metrics by date from an Access table. The date range in question is basically 09/01/2007 - 02/12/2008. For some reason, the report will not pull anything from 2008. When I specifically state in the select expert that the...

Hi there-- I am building a report that has 8 fields, the first being date (mm/dd/yyyy). The report reflects a month of data and has subtotals grouped on both the weekly and monthly level. I successfully used the WeightedAverage function to calculate subtotals at the weekly level for 3...

Hi There-- I can open the Excel template I want from Access, however, the underlying data query does not run upon opening. The code I am using is as follows: Private Sub cmdProtocol_Click() Dim oXL As Object Dim oExcel As Object Dim sFullPath As String sFullPath = "...template.xlt" Set...

Hi-- When trying to use a loop to import multiple worksheets from a workbook, I get run time error 3051: "MS Jet Engine cannot open (string)...it is already open by another user or you need permission to view its data." The file in question is neither in use by another user or...

Hi there, I am trying to use a DLookup function to scan an existing table for a specified date value. If the value is found, the procedure will terminate with a message box. If the value is not found, the procedure will continue and import the specified Excel sheet. The code I wrote to do...

Hi-- This is another question related to the code posted in the "Error Handler Only Works Once" thread. I implemented the suggestions provided regarding the error handler and made some additional necessary tweaks to the code. The problem I am having now is that the outer loop goes to "exit...

Hi-- I wrote some code the logic of which should do the following: 1) Loops through a column of values (inner loop) 2) Looks for 4 specific values 3) When it finds any of these 4 values, copies the entire row it is in 4) Pastes this row to another worksheet in the same workbook 5) Go back and...