Any Idea how I can display this data in this Table (pics) 1

[nervous2]

I have a Database table in which we have information for our paint codes,

This database when loaded with our software will display many types of tests we have done with this paint and we manually enter in the results, when I open up this same table in access I noticed that each test we have done the software created a new entry, therefore I have several entries for the same product code, and since we have several tests for I am unable to specifically pull out the data I need.

For example I need to create a data sheet for our customers displaying the bake time for these all our products the Product code (formkey) is listed multiple times but all I need is to record the Bake (TargetAlphaValue) time, I have shown in a jpg what I am looking for, would anyone here know how to pull out only the TargetAlphaValue and associate it to the bake and formkey?

 

[lbass]

Looks like you could use a record selection formula like this:

{table.testdescription} = "Bake"

-LB

 

[nervous2]

Thanks for the help,
if you refer to the jpg I posted and looking at formkey product HS-0848-H, can specifically call up the field 15' @ 190C with this record selection? this data 15' @ 190C is unique to HS-0848-H so it must be this specific field.

On the example shown all the bake times are the same but this is just a screen shot showing a few product in general there are thousands with many different bake times.

Could you please expand the suggestion a little further I am a novice at this and unfortunately I need to move VERY slow when trying to understand.

Thanks

 

[nervous2]

Got IT!!!
Thanks a bunch great help!

 

[nervous2]

New Problem now, I have been struggling with this but I don't know how to approach this.

I magged to show the bake time with the record selection you advised now I need to show the Gloss PTM01 (same table) but because I restricted the record to "bake" this is the only data I can pull up. I basically need to create a copy of the database telling one copy to restrict the test to "Bake" the other to restrict it to "gloss" any suggestions?

Thanks

 

[lbass]

Change the record selection to:

{table.testdescription} in ["Bake","Gloss PTM01"]

Then insert a group on the description field.

-LB

 

[nervous2]

Thanks and sorry for the double post I thought this might require a formula therefore I reposted it there.

I followed your instructions and it seems like it is working to some degree but I now have a formating issue. I have a table / form which I am producing and in the form I have the bake time and Gloss as well as some other test results, the form / table is located in the details section and seems to be working but I'm stuck at these 3 test listings. When I create a new group as suggested the bake times and Gloss now sits in the header of the Report / Form. I need these to fit inside the table I created can this be done given this situation? This one table / form I am creating will display all my data including different test results on one sheet

Thanks

 

[lbass]

I can't really answer this as I have no idea how you are implementing this form.

-LB