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....bec ause 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  2745 
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)...th e 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...rat her 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 must be many know the answer here.
thanks
|
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 must be many know the answer here.
thanks
|
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 confused. When I was using
Directx everything was being run from a while loop, so that was no problem
for me in seeing where to place conditional statements and other functions.
With windows forms do I need to have an event and eventhandler? it...
|
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
communicate with a MySQL database table on a web server, from inside
of my company's Access-VBA application. I know VBA pretty well but
have never before needed to do this HTTP/XML/MySQL type functions.
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
