Hey guys, I'm new here

and also pretty new to access

I'm creating a database at work, and need to be able to search things within it to find the right part number in our case...

heres a sample of what the table looks like:

Part # Size Press A FlowRate Press B FlowRate Press C Flow Rate

124 1 0.52 0.82 0.65

125 2 0.23 0.56 0.74

126 3 0.29 0.82 0.24

127 SPCL 0.37 0.05 0.37

if it doesnt come out right on the thread..here are the columns individually:

Part #:

124

125

126

127

Size:

1

2

3

SPCL

Pressure A Flow Rate:

0.52

0.23

0.29

0.37

Press B FlowRate

0.82

0.56

0.82

0.05

etc..

So the part # is always different...

(the list has about 78 different part numbers)

but there are only 4 different sizes: 1,2,3 or SPCL....so if kept going down the list you would see some mroe size 1, 2,3's,..SPCL's...etc...

now heres the tricky part for me

he wants a form or a search box of sort to do the following:

example: "ok I want a size 1, with Pressure C"

so once you search that it finds all the numbers with the criteria of a certain size under a particular pressure....because whoever is searching is not going to know the flow rate number such as 0.36 or the exact part number

I've looked up tutorials and all....but I haven't found help

I think its tricky because the numbers below the flow rate are not part of the search criteria....

its the the actual rows and not the values under each row such as Name: or Size...

so the ultimate goal is to pull up something by size AND at the same time...mention a pressure...(so the header of the table because there are about 30 pressurs) to find all of the corresponding part numbers with that size and that hav a flow rate at that pressure (because not all the part numbers have a flow rate at a certain pressure, it says NA for now)

so if someone could help I would really appreciate it.

Thanks