By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,773 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,773 IT Pros & Developers. It's quick & easy.

Beginner need Microsoft access 2003 help with forms and searching

P: 10
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
Jun 8 '07 #1
Share this Question
Share on Google+
5 Replies

P: 24
you can just use a query following watever criteria in order to single out the result you want. You can use something along the guidelines of

LIKE *& ...... &* : which would return a value similar to what the ... are
or you can use numerical criteria in order to filter the right answer
Jun 8 '07 #2

P: 10
K thanks, but I'm not 100 % sure if I'm comprehending exactly what you are saying. I just found it weird because typically when they use examples in tutorials, you always see Name, Address, Phone # as the headers and each of those have individual inputs.
My database on the other hand, has Part #, Size, (the part #, there is only one per part obviously)...the size can range..only 4 choices to choose from

but the flow rate part...
the headers are 3000 psi flow rate, 2800 psi flow rate, 2600 psi flow rate...etc....
the values for that are not THAT important...rather I want to filter out the header itself...and not the contents of what is input under the headers ...

so if anyone else has any input, that would be great.
Thanks
Jun 11 '07 #3

P: 27
I am not sure if I understood you right. If you are not sure about the search string then as mentioned by the previous replier: just use the wild card. If that is not what you want then please re-state your question.
Just an example:
SELECT (field names go here seperated by commas)
FROM (table name goes here)
WHERE (search criteria eg, field name LIKE 'lookup%')
For wild card you may use (?, & or %).
I hope this will help
Jun 12 '07 #4

P: 10
I am not sure if I understood you right. If you are not sure about the search string then as mentioned by the previous replier: just use the wild card. If that is not what you want then please re-state your question.
Just an example:
SELECT (field names go here seperated by commas)
FROM (table name goes here)
WHERE (search criteria eg, field name LIKE 'lookup%')
For wild card you may use (?, & or %).
I hope this will help
K thanks..I'll clear it up....

if you go here:
http://www.access-programmers.co.uk/forums/showthread.php?t=129855post#4

post #4..my last one....
theres a better explanation of my issue..and I have a the zip files there so people can download it to get a better view on what I'm asking...I did make a bit of progress though and am almost done with my form...its all explained in the link above which has the download files..so if someone could help me ...
that would be great
Jun 13 '07 #5

P: 10
Now that I have a little bit of progress done..can anyone help with my current status ^^^(in the post above)?
Jun 13 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.