Search results for query: *

Is it possible to export unicode characters to a Tab Delimited format? I have a report built which contains a mix of Japanese data and English data. The data appears correct in the report viewer, however when the data is exported as a tab delimited file, the Japanese data is saved as a series of...

Trying to compare the overall average and median of a field in my report to the average for one of the groups. Field is # of months, and the data has been grouped by a group called Aging into two values fresh and aged. I want to calculate the average and median number of months for just the...

I am trying to import a specific worksheet from an excel document into Access. The excel document contains two tabs, UploadTest, and UsageExport. I am trying to figure out how to import only the data in the UsageExport tab, which is the second tab in the document. The problem is that the code...

Working on a form where I need to calculate a date in one text box based on data in two others. There are three textboxes involved. I have tried searching, but for some reason, the search function does not seem to work if I add a second word to the search. txtType (text) txtEventDate...

Need to find a way to store multiple values in my access 2002 database. Each record in the main table can be associated with multiple products. I have a table set up for product name, (tblProduct), my main table (tblMain), and a third table to store the values for products associated with each...

I have a form used for data entry by 2 people based on a table. Until yesterday, the form was set up so that the first record was record 1, and the form showed each record in ascending order. Yesterday, the form started showing records in a seemingly random order. The order is correct in...

I need to figure a way to suppress vowels from a string of company names. For example, Ford would return Frd etc any ideas? thanks kirk

I am faced with the task of generating a report on the contents of our info desktop. There are 5 levels of folders/reports. Each report or folder has a unique id #, as well as a parentid #. The parentid is 0 for the top level folders. I wish to generate a report such that each level is...

in CR7, I have 2 reports that include subreports that work fine in Crystal, but when I schedule them on the Crystal Info Desktop, the main report runs fine, but the subreports do not seem to refresh, and show the data from the day I last modified the report. They worked correctly in the past...

I have a group of data with a summary. I want to conditionally suppress the details of the group when the count is even. I have hand coded the following: Count ({@groupprod}, {@groupprod}) in [2,4,6,8,10,12,14,16,18,20] This works fine, but rather than continuing this, I would like to simply...

I am having trouble solving a problem. I have grouped a number of products by their associated license number. Each group (license) therefore has a number of products associated with them (1-50). I need to group the licenses by the number of products associated with it, then get a total of the...