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
5 2714
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
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
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
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
Now that I have a little bit of progress done..can anyone help with my current status ^^^(in the post above)?
Sign in to post your reply or Sign up for a free account.
Similar topics
by: lester |
last post by:
a pre-beginner's question:
what is the pros and cons of .net, compared to ++
I am wondering what can I get if I continue to learn C# after I have learned
C --> C++ --> C# ??
I think there...
|
by: lester |
last post by:
a pre-beginner's question:
what is the pros and cons of .net, compared to ++
I am wondering what can I get if I continue to learn C# after I have learned
C --> C++ --> C# ??
I think there...
|
by: Neal |
last post by:
managed C++
VS 2003
I have a beginner question about windows forms....
I need to call a function when a certain limit has been reached, now with
the way VS sets up the .NET windows Form I get...
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |