Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ambersd12

    How to search values on a form

    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?
  2. ambersd12

    Using a query to search data instead of primary key

    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?
  3. ambersd12

    Using a query to search data instead of primary key

    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 "?="...
  4. ambersd12

    Using a query to search data instead of primary key

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

    Using a query to search data instead of primary key

    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...
  6. ambersd12

    Using a query to search data instead of primary key

    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...
  7. ambersd12

    Using a query to search data instead of primary key

    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?
  8. ambersd12

    Using a query to search data instead of primary key

    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].*...
  9. ambersd12

    Adding a new record to a table

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

    Adding a new record to a table

    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...
  11. ambersd12

    Adding a new record to a table

    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...
  12. ambersd12

    Adding a new record to a table

    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.

Part and Inventory Search

Back
Top