Search results for query: *

How do I search a form by numbers that I want to ask a person to enter? The form I'm working with is "HMBA logB Query". I'm pretty confused as to the features of forms as well, are there any good online reading material?

Yea, the columns aren't numeric, I have the error in so a number in the table looks like 3.62(4), so in access I have them as text. I have 6 columns of "[?=]" [?=1E-1], 5E-1, 1, 2, 5, 0. so would you just do an AND statement for all the columns?

So the mediafire thing works, the other ones do not. There are the four tables in the excel document, from those tables I want to be able to search the "?=" columns. So for example I'm interested in any [Metal OS] that has a value between say 2 and 4, so it should return and metal at any "?="...

Maybe this will work?http://www.mediafire.com/?sk58m7vn16xtkbw

I'm not quite sure how u can attach a file to these threads. The step 3 things only says type or paste full url, and the files are saved to my desktop computer...

The "where" code doesn't work, or isn't returning anything. The union query, while works, and might be cleaner than what I was using, doesn't do what I need. I don't want to search by [metal os]. I want to search by values that are listed in the columns of a table. So I want the query to return...

So some of the values are actually text, instead of numbers, will that make it not work? Will that only search the one table, instead of all 4?

Right now I have a a query that searches 4 tables based on the primary key. It returns any values associated with that primary key. The primary key is [Metal OS]. This is my query: SELECT [HMBA B101, 25C].[Metal OS], [HMBA B101, 25C].*, [HMBA B102,25C].*, [HMBA B103, 25C].*, [HMBA B104, 25C].*...

I got it to work :D Thanks for all the help!

Yes [Metal OS] is my primary key. So are you saying that if I want to add a new metal, I need to add one to every table in the query, even if there isn't data for that metal? Or are you saying that because I don't have every column filled access won't except it as a new "record"? What...

This is my query: SELECT [HMBA B101, 25C].[Metal OS], [HMBA B101, 25C].*, [HMBA B102,25C].*, [HMBA B103, 25C].*, [HMBA B104, 25C].* FROM (([HMBA B101, 25C] INNER JOIN [HMBA B102, 25C] ON [HMBA B101, 25C].[Metal OS]=[HMBA B102, 25C].[Metal OS]) INNER JOIN [HMBA B103, 25C] ON ([HMBA B101...

So I'm trying to add a new record to a table and have it appear in my query. I've added it to my table, but when I use my query the record doesn't show. I've tried to update my query, but because I'm using the *, it won't. I have no idea what to do.