Search results for query: *

I am trying to extract characters from a string of text. The location of the characters is not always in the same position, however they are always surrounded by "__" characters. In excel I am able to use the MID and FIND functions to make it work. Example... the string looks like this...

The Contains function in Auto filter is very powerful, because it looks for the string being asked for. The string being asked for could be in the middle of many, many characters or just a few. The problem with a vlookup, or index/match in a formula is it requires each character be accounted...

Here's my data PG Month1 M6 100 M6 50 T5 50 C3 25 C3 25 All within Section 1 of a larger report. I'd like to see subtotals on each PG respectively so the report should look similar to this. PG Month1 M6 total 150 T5 total 50 C3 total 50 Grand Tot 250 I'm...

You are correct, it is the page layout on the screen. As I am viewing the screen, I've created 4 reports which lay in rectangular shapes on the screen in the same page layout. However, after printing, there is an enormous amount of white space left to the outside. I'd like to resize...

I've created four reports on one sheet, now I am trying to get them to fill the page (when printed), for both aesthetics, and viewability. However, since I created them yesterday (shrinking by click and hold grabbing the handles and moving in, today I can not grab the handles and resize the...

I have created a report that displays on the top row ww1, ww2, ww3, ww4. However what is requested, is a rolling 4 week aggregation, so that at the close of business in ww5, the data contained in the pivot table will be for WW2 through ww5, aggregated. Thus, the top row will now only be one...

How do a create a relationship (similar to the way MSAccess)between different data providers. Both data providers have at least one identical field, thus it could be the index, so how can I get the result to display the results. example... Data provider1 Machine Name Program Tool A...

The top row represents successive dates. The first column represents the products. The table is populated with qties of the product over dates in the top row. I would like to get these values by looking them up from another table (similar in structure), however the table being populated has a...

Sample of the what I'd like the output report to look like Group March April May CDRP Group NC 100 100 50 ND 50 100 50 CDRP G 150 200 100 % of T 38% 50% 25% WEUY Group WC 100 200 200 WX 150 0 100 WEUY G 250 200 300 % of T 62% 50%...

In my access report I have created the sums of product groups in the footer. And in the Report footer I have the sums of all the group footer, giving the Grand Total. What I would like to accomplish is to show what percentage the sum of the groups is to the Grand total, and be able to display...