Help, Beginner to Access 2003, need database search form help

[ebernedo]

Hey guys, I'm new here and I'd like to introduce myself first.
My name is Erick and I'm on here because I have an assignment at work to create this database, and I'm pretty new to Microsoft Access 2003. I'm doing an engineering internship and am currently a student with one more year left for my bachelor's degree. I'm glad im here and I hope you guys can help me out.


K to the problem now:
I am creating a database...and have created a table already...this is all in the attached document

heres the goal:
to create a search form..which can filter out by Size and Pressure.
As you can see, there are only 4 choices for size: 1,2,3 or SPCL
so I want that to be a filter...
the tricky part for me is this:
As you see the other headers: you have 3000psi flow rate, 2800 psi flow rate, 2600psi flow rate etc....
and each of those have values under each header...I do NOT want to filter by those values..those are not important to me...
What I want to try to do is to filter by the header itself, which is the pressures....
example:
I want to find a Size 3, with 2600psi, (meaning to show all of the values in the table that have a Size 3, that have values with 2600 psi flow rate (and show what the corresponing flow rates are)

This is because not all of the part numbers have a flow rate at certain pressures..this is why I put NA...should I was also thinking should I just take out the NA...because otherwise It seems like eeverything will come up when I filter by pressure...

also I would like to have a separate part number filter maybe..(not as important) so I could look down a list..select the part number and get all of the data for it...

the latter isn't as important...

but if you guys could help me out with how to filter mainly by size( which isnt that hard) and by pressure (which is the horizitonal filtering rather than vertical values) then that would be great
I would really appreciate it because I'm a newb to access
Thanks

 

[Anonymous_354]

Ok, I'd build something that has to do with crosstab or select queries. I've played around with it a bit and am getting closer, but still a ways off.

 

[Grafixx01]

Are you trying to JUST search by the 2600psi? or do you want a user to be able to select the PSI and Size they want to search by?

 

[ebernedo]

Hey guys, thanks for the input..and actually..I got one step closer..but am stuck on one very important part

I went under the sample database part of this forum and found the one I needed
I want my search form to be somewhat similiar to the database on the download: dbSearchExample.zip-->dbSearchExample-->Forms-->frmSearch

If you look there...you can filter out by more than one thing..such as color...or company..of a combination of the both...
so if you want the people with favoirte color red..then thats what you get..
or under a company..then that...or company and color..to filter more in depth

for mine open up the following:
Discs.zip--->Discs--->Forms--->Disc Search Form

On Mine I already have the size filter..so I can search by one size...or multiple..I copied the code from the sample and made it into my own...
and it works

so just like the sample search form..I want to add another drop down box/list on the form so I can filter more in depth and be more specific (just like company AND favorite color search on sample)

but see what I want in my list...is the list of the HEADERS....because if you look on the table..each pressure..3000psi, 2800psi...each of these headers has a list of flow rates which are numbers with decimal places...I don't want to worry about the those numbers

I want to sort it out by the list of headers or pressures...so on another drop down box have it say: 3000psi,2800 psi..2700psi...etc....
this makes it tricky for me and I dont know what to do

and Grafixx01, my answer to your question is BOTH...
so that if a user wants...they can have the choice of example: selecting all of the matching part numbers that are Size 2 and have a corresponding flow rate at say 2600 PSI...because if i put NA on the table..that means at that pressure..there doesn't exist a flow rate...(I think that has to do with if statments)
but right now the most important is to create a list of the headers..and get them to match up with the search results...
so please if anyone could help..I would really appreciate it

 

[Grafixx01]

ebernedo,

I'll look at it in the morning when I get to work, possibly tonight at home but I have homework to do so we'll see. What you're asking is easy though.

 

[ebernedo]

ebernedo,

I'll look at it in the morning when I get to work, possibly tonight at home but I have homework to do so we'll see. What you're asking is easy though.

Hey if you could..I'd appreciate it a lot...I'm a newb at access lol....but I'm learning..but yeah that would be great though and I'm glad that you find it easy

 

[ebernedo]

^^^^^hey if someone could help I would appreciate it, because I've been looking and still have not been able to find the right solution