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 TouchToneTommy 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: *

  • Users: Twillz
  • Content: Threads
  • Order by date
  1. Twillz

    Help with query

    Can someone please me help with this query? Here's what I'm trying to do. I have a report that shows: item number, item description, qty, etc. The problem I’m having is that I want to show an alias for the item if it has one, if not I want the item description to show instead, but only the...
  2. Twillz

    Total Query

    I have this query that is a total query. Here are the field in the query: Part = Group Qty = Sum What I would to do is have a inventory form that show the parts(group), the Qty(sum) and ordered, I have the form and it shows the parts, and qty but I can't update the ordered field...
  3. Twillz

    Query

    Can you write a query that would look in different tables for a record from what is enter on a search form. Example Table1 Table2 ID Id Customer Customer Reason Reason Date Date The records would be looked up by...
  4. Twillz

    search form that find records in multi tables

    Thanks for your help. Can anybody help me? I would like to create a search form that can find records from multi tables that have forms linked to the tables. And when the record is found it will open the form that is linked to the table where the record is stored. Can somone please help me...
  5. Twillz

    Search Form

    I hope some one can help me. I want to make a search form that can search more than one table (I have 14 tables)and when the record is find its opens the form where the record is stored. The records would be search by their "order number". Thank you

Part and Inventory Search

Back
Top