Simple formula question

[nervous2]

I have an access DB

http://www.fileden.com/files/2006/10/23/311463/infopathdatawith data.jpg

I'm trying to display the 2 cells circled in red. I am able to display the proper results when I add the feild in the (select expert and set a function such as {FMQC.Testdesc} startswith "Part")

BUT....

Now I need to add the info for the same key (under Film.T the 0.8 and 2.2 these fields are not marked on this jpg but they are located 8 rows under the red circles, when I try to use the same technique as above I get into the formula editor where I see my original formula that I did to show the red circles If I edit the formula again to show the new data to display the 0.8 and 2.2 then I alter the formula that shows the red circles how can I right 2 separate formulas or in this case maybe 4 separate formulas.

thanks.



but any formula I try to
run either crashes the computer or turns up unsuccessful, would anyone here
know ho to run a rule that will display the circled area. I'm confused
because the first cell (key is repetitive)

 

[lbass]

Why wouldn't you just use a record selection formula like:

(
{FMQC.Testdesc} startswith "Part" or
{FMQC.Testdesc} startswith "Film.T"
)

-LB

 

[nervous2]

Will try but I am confused on this.

column five has partial data I want to show but in the case of HA-0107-M I need to show Part size range 40 -45(45 is column 7) then I need to show the Film T PTM 28 (which is 0.8 - 2.2 (2.2 is column 7) since they use the same key I can't get these to show correctly I am looking for a formula that basically will say
(4 separate field objects)
Using Key Ha-0107-M when column 2 starts with Part then plug column 5

Using Key Ha-0107-M when column 2 starts with Part then plug column 7

Using Key Ha-0107-M when column 2 starts with Film then plug column 5

Using Key Ha-0107-M when column 2 starts with Film then plug column 7

Problem is the only way I now how to do this is inserting field object (5 in this case and using Part) then using the select expert and putting in the filters but then when I need to use field 5 and filter using the Film text in column 2 I see the formula I originally created above and if I alter it it changes the field I had previously entered. The record selection you showed me I am unsure how to enter this in, do I add group field in 5 then edit it or do I need to start with a whole new formula?

 

[lbass]

I'm not sure I follow, but try this. Go to the field explorer->formula->new and create this formula {@col5}:

if {table.key} = "Ha-0107-M" then
(
if {table.col2} startswith "Part" then
<add your plug here without the carets>
else
if {table.col2} startswith "Film" then
<add your other plug here without the carets>
) else
{table.col5}

You can use the same syntax for column 7. You would use these two formulas instead of the columns themselves.

-LB

 

[nervous2]

thanks for the help I really appreciate it. I have been unsuccessful with the last attempt I thought it was working properly until I added the Film data and the data wasn't' being pulled properly. I was wondering if you could give me another suggestion please. I have recreated the jpg file to represent my data better

http://www.fileden.com/files/2006/10/23/311463/tdsheet.jpg

Please note that I will be listing this data for 1000's of keys therefore I will not specify the exact key in the formula as I expect this report to be 1000's of pages. Listing this data for each key, the data in the jpg shows the data for only 3 keys which I have labeled in colour.

Thanks for the help I can't believe this has taken me 1 day now and I still can't tackle this.

 

[lbass]

I'm sorry, but this data means nothing to me. You need to more clearly describe what you mean to do. It appears that you are trying to replace existing data with some hard coded data, but I'm not sure.

Also, when a suggestion doesn't work, you should provide feedback that helps us understand why or in what way it doesn't work.

-LB